S
SteveH
Sorry already posted something similar but I don't think I have been
very clear so here goes again.
I have a master spreadsheet containing lots of worksheets. Each
worksheet holds performance data for specfic fund and each worksheet is
named with the funds shortname.
I have a number of fund spreadsheets in residing in one directory each
with the long name for that fund and containing static fund data.
Within each fund spreadsheet there is a worksheet named after the fund
shortname (as in the master spreadsheet).
For each worksheet in the master spreadsheet I need to find the
matching worksheet in the correct fund spreadsheet and copy the data
across. This means copying about 20sets of data from seperate
worksheets in the master spreadsheet into the worksheet of the correct
fund spreadsheet. Each time the range of data to be copied is B265.
Hope this makes sense and I hope you can help me!
Steve
very clear so here goes again.
I have a master spreadsheet containing lots of worksheets. Each
worksheet holds performance data for specfic fund and each worksheet is
named with the funds shortname.
I have a number of fund spreadsheets in residing in one directory each
with the long name for that fund and containing static fund data.
Within each fund spreadsheet there is a worksheet named after the fund
shortname (as in the master spreadsheet).
For each worksheet in the master spreadsheet I need to find the
matching worksheet in the correct fund spreadsheet and copy the data
across. This means copying about 20sets of data from seperate
worksheets in the master spreadsheet into the worksheet of the correct
fund spreadsheet. Each time the range of data to be copied is B265.
Hope this makes sense and I hope you can help me!
Steve