Recent content by shinkley

Skip, 1) There are several sheets in this workbook. I would like to report the total for each sheet on a totals sheet, so the user doesn't have to go through each sheet to find the totals for each product. 2) The flat file imported from excel has exceeded the row capacity set by excel. I...

I have a workbook with several worksheets. On each worksheet, the last row has the sum total for the data. I would like to copy each 'sum row' to a worksheet called 'Totals'. This worksheet is already created. I would like to first sheets totals to be in row1, the second sheet in row2, and...

I have a macro that imports a file. I wish to code the following logic, how would I go about doing it? If (blank workbook is open) insert into blank workbook else new workbook I can use the workbooks.add stmt to always open a new workbook, but i would prefer to import into workbook if...

I have an Excel spreadsheet that is generated from a flat file. The file has different sections with group totals. I have set up a macro to import the data and place it onto different sheets. however, the data is comma seperated. I am trying to loop though each worksheet, and use the...

you have a semi-colon after your set serveroutput on stmt