• Finding data in Microsoft Excel spreadsheet using a macro

    I'm using Microsoft Excel and I'm looking to find the last row that contains data in a specific column on my spreadsheet. How can I do that with a macro? Thank you!

    ITKE380,345 pointsBadges:
  • Change to Crystal report affect export to Excel

    We have a Crystal Report that has been being exported to Excel for a few months. It is then imported into an Excel template with macros. We have used this report and the macros have worked properly for several months. Recently I made a change to the Crystal report, adding subtotals to the footer of...

    cbonnell5 pointsBadges:
  • What is the next step for an Excel database?

    I have been developing Excel applications for 6 years. Creating Scheduling, Invoicing, Estimating, HR & CRM applications with Excel exclusively. As my applications and customer needs get larger i have been running into some headaches with Excel as a database. Customers want to share workbooks...

    Excel4Business15 pointsBadges:
  • How to use Excel icon in SAP to export a report

    I am using a transaction code ZASLIDET to pull a report. This T-code has an Excel icon which should allow me to export the report in a clean format, but when I click on that excel icon, I am only getting blank spreadsheets. How to enable this excel feature to export the report?

    Larisaivanova5 pointsBadges:
  • Reading Microsoft Excel using C#?

    I need help ASAP! Can anyone help me? I need to figure out how I can read an important Microsoft Excel file using C#? Thank you very much.

    ITKE380,345 pointsBadges:
  • Microsoft Excel macro If Script

    I'm no macro expert, so I need a little helps with this. Here is what I am trying to do: If (2,36)="2C" then (2,37)="Physician" If (2,36)="1E" then (2,37)="nurse". Then I need to apply this to the whole column. so that if (3,36)="2C" then (3,37)="Physician" and so on down the column. What I am...

    PatrickKP5 pointsBadges:
  • Export contacts info from Outlook 2007

    Can someone suggest the easiest way to export my personal Contact information from Office Outlook 2007? I want to migrate my personal Contact information from office Outlook to my home computer. Early response will be much appreciated as I am leaving office from this Friday (1/30). Thank you.

    SbElectric2,540 pointsBadges:
  • $ sign and numbers after decimal

    One of my columns is for a $ amount that never changes for that particular person. Recently, I wrapped the text to print out a readable copy. For some reason I lost all the $ signs in that column. Also, when changing an amount such as $176.37, the .37 will not stay.  The $ sign is true for all 129...

    kaykay9085 pointsBadges:
  • Microsoft Excel: How can I display the users names of the top three counts

    In my Excel spreadsheet, is there a way I can display the users names of the top three counts? Thank you.

    Userdj25 pointsBadges:
  • Monthly call volumes vs. weekly call volumes for determining required head count at call center

    I need an advice on what is the industry to calculate the monthly required headcount of a single service at contact center. I'm using erlang C calculator on Excel and one of the inputs required for this formula is the per interval (1 hour) number of calls. But this formula does not define the...

    aalsbiei10 pointsBadges:
  • Saving Excel spreadsheet to multiple locations

    Is there a way to save my excel spreadsheet to both my computer file and the evernote file without the extra save as step?

    jerrydavisvybranz5 pointsBadges:
  • Microsoft Excel report generation from Oracle Forms 10g

    what is the procedure or builtins used to generate a excel report from application server in oracle forms 10G.

    Somnath895 pointsBadges:
  • Creating an Excel 2010 comparative monthly and yearly report to reflect trends

    I need your help on what information I need to enter to create a pivot table and a chart to compare in Excel 2010 to compare the monthly and yearly denials.

    guerreroaa55 pointsBadges:
  • Microsoft Excel: Setting for default sort based on remaining columns

    In Microsoft Excel, is there any setting for default sort based on remaining columns?

    addankirao5 pointsBadges:
  • How to repair and recover corrupt MS excel file?

    How to repair and recover corrupt MS excel file? I am unable to open corrupt MS Excel file due to virus infected, I have crucial Workbook sheet got lost, so how to get back corrupted MS Excel file. Please help me.

    DredSelpy5 pointsBadges:
  • Transfer data from iSeries RPG to Excel

    How can I transfer data from iSeries RPG to Microsoft Excel?

    Rmw10 pointsBadges:
  • AS/400 file to Excel with Headers and Footers

    I need to attach an Excel s/sheet to an email. I currently do that via the CPYTOIMPF as a CSV file but this doesnt give give me the true Excel Header row, which is a requirement. Is there any easy way to do this?

    NJFred35 pointsBadges:
  • Can a MCF file be converted to PDF or Excel? If so, how?

    I received a file in MCF and cannot open it. Can I convert it to a PDF or Excel file? If so, how can I do it?

    Boro565 pointsBadges:
  • Java applet with multiple fields in an Excel sheet

    I need to make an applet with multiple fields in an Excel sheet. This applet would return us data based on the value we enter in the fields. Could you please tell me how can I do this or at least what do I need to read for doing this?

    Kaustav0000165 pointsBadges:
  • Microsoft Excel will not let me save or make changes to document

    The message reads "You don't have permission to save in this location. Contact the administrator to obtain permission." How can I fix this?

    Johnandjune5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following