Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining worksheets | Excel Discussion (Misc queries) | |||
Combining worksheets | Excel Worksheet Functions | |||
Combining worksheets | Excel Worksheet Functions | |||
Combining worksheets | Excel Worksheet Functions | |||
Combining worksheets | Excel Worksheet Functions |