combining worksheets
Hello all, I am trying to find out how to write a macro that will search for
an excel spreadsheet and combine it with the worksheet I am currently using. for example: I type the name of the worksheet i want to combine in a cell and press the macro hotkey. excel then looks up that worksheet in a specified folder called "pool" where all the necessary workbooks are saved. excel then combines the contents of both workbooks (ignoring empty cells) on to one page. The macro recorder seems to be able to do the copy and pasting I am having trouble with the look up part. Thanks in advance for your help. |
combining worksheets
This should get you pretty close to where you want to be:
http://www.rondebruin.nl/summary.htm Regards, Ryan--- -- RyGuy "officelackey" wrote: Hello all, I am trying to find out how to write a macro that will search for an excel spreadsheet and combine it with the worksheet I am currently using. for example: I type the name of the worksheet i want to combine in a cell and press the macro hotkey. excel then looks up that worksheet in a specified folder called "pool" where all the necessary workbooks are saved. excel then combines the contents of both workbooks (ignoring empty cells) on to one page. The macro recorder seems to be able to do the copy and pasting I am having trouble with the look up part. Thanks in advance for your help. |
All times are GMT +1. The time now is 09:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com