Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Several named Range in many sheets to a summary sheet
Dear Experts:
I have defined the dynamic range using "offset" to overcome the number of rows which is variable. From the summary sheet I have defined the name of the range such as "dbase1", "dbase2", etc... of each sheet. My question is how can we copy this name range to be combined to the summary sheet. the structures( number of columns)of all sheets are all the same. I have thought of starting copying dbase1 to A9, then using End and xldown. But could you please explain what macro can we use to handle this task. Many thanks, Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 SP3 Copy Worksheet with another sheet named range now # | Excel Discussion (Misc queries) | |||
Make all values of a 3D named range appear on summary sheet | Excel Discussion (Misc queries) | |||
Sheets named from range, and copy data? | Excel Discussion (Misc queries) | |||
Copy named range from file list to summary workbook | Excel Programming | |||
copy all named ranges in a sheet to seperate sheets | Excel Programming |