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 (B265).
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 B265 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
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 (B265).
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 B265 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