Copy data from multiple worksheets to worksheets in a number of other spreadsheets

S

SteveH

I have a performance spreadsheet containing multiple worksheets, each
worksheet holds performance data for an individual fund. Each of these
funds has its own spreadsheet containing static information about the
fund.

I need macro that will copy the performance data from the performance
spreadsheet to each individual fund spreadsheet. The cells to be copied
are the same for each worksheet (B2:D65).

Each worksheet in the performance spreadsheet is named with a fund
code, this fund code is also the name of the respective worksheet in
each fund spreadsheet.

I need the macro to copy cells B2:D65 from each worksheet where the
performance spreadsheet.worksheet name = fund spreadsheet.worksheet
name. All the fund spreadsheets reside in the one directory. Thereofre
the macro must match on worksheet names within each spreadsheet.

Thanks!
Steve
 
S

SteveH

Looks good thanks but need something else too.

I need to loop through all spreadsheets in a single directory and when
I find a spreadsheet which has a worksheet name the same as one of the
worksheet names in the master spreadsheet then the data in the master
spreadsheet is copied to the individual spreadsheet in the named
directory.

Hope this makes sense. Here is an example:

Master spreadsheet Worksheet Name - OGASIAF
Fund Spreadsheet Name: Asian Equity Share Class A.xls and Worksheet
Name - OGASIAF

Therefore the data in the master spreadsheet will get copied to the
worksheet in the fund spreadsheet.

There are about 20 instances of this, where I need to copy fund
performance data to individual fund spreadsheets in a directory. Each
time it is the same range of cells being copied.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top