Search results for query: *

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...