Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I wish to automatically copy a range of cells from one worksheet to several
other worksheets for which their names are contained in a range. For example: IN the Active Worksheet: Range a1:a5 contains a list of established worksheet names as follows (note: there are other worksheets that are not in this list): Facility 1 Facility 2 Facility 3 Facility 4 Facility 5 Range b10:d50 contains the cells I wish to copy to worksheet named in the above range. So, is there a simple macro that can copy b10:d50 in the specified worksheets that are indicated in a1:a5 ? Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro to pull in specific data into multiple worksheets in a workb | Excel Discussion (Misc queries) | |||
add new data to specific columns in multiple worksheets | New Users to Excel | |||
Copy data in multiple worksheets | New Users to Excel | |||
Copy only certain data from multiple worksheets | Excel Discussion (Misc queries) | |||
How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions |