LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default Copy data to multiple specific worksheets?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to pull in specific data into multiple worksheets in a workb murkaboris Excel Discussion (Misc queries) 0 April 14th 09 06:25 PM
add new data to specific columns in multiple worksheets juliebythesea New Users to Excel 2 July 10th 07 01:24 AM
Copy data in multiple worksheets kfletchb New Users to Excel 2 August 11th 06 12:18 AM
Copy only certain data from multiple worksheets Matt Excel Discussion (Misc queries) 0 February 10th 06 03:06 PM
How do I retrieve data (specific cells) from multiple worksheets on a shared drive jbean Excel Worksheet Functions 1 November 10th 04 09:26 PM


All times are GMT +1. The time now is 10:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"