Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compiling Multiple Spreadsheets to One
I am new at VBA Code. I am trying to take multiple
spreadsheets and combine them into one summary sheet. I am not quite sure how to do this since I can have any number of spreadsheets that I am trying to combine into this summary the good thing is the sheets always have the same range. I believe I need to do a loop but I am not sure how to identify the next empty cell in my summary sheet. Please Help.. Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compiling Multiple Spreadsheets to One
Thanks Boss I really appreciate it.
Chris -----Original Message----- Try this example Cris http://www.rondebruin.nl/copy2.htm -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "Chris White" wrote in message ... I am new at VBA Code. I am trying to take multiple spreadsheets and combine them into one summary sheet. I am not quite sure how to do this since I can have any number of spreadsheets that I am trying to combine into this summary the good thing is the sheets always have the same range. I believe I need to do a loop but I am not sure how to identify the next empty cell in my summary sheet. Please Help.. Chris . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compiling data from multiple Excel sheets - macro? | Excel Worksheet Functions | |||
compiling data from multiple excel files | Excel Discussion (Misc queries) | |||
Compiling information from multiple workbooks and summarizing | Excel Worksheet Functions | |||
Compiling data from multiple worksheets into one worksheet | Excel Discussion (Misc queries) | |||
Compiling information from multiple excel files | Excel Discussion (Misc queries) |