| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
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  65).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 65 from each worksheet where theperformance 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 |
|
|
|
|||
|
|
| |
|
Guest
Posts: n/a
|
Try this example Steve
http://www.rondebruin.nl/copy4.htm -- Regards Ron de Bruin http://www.rondebruin.nl "SteveH" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... >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 65).> > 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 65 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 > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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 Ron de Bruin wrote: > Try this example Steve > http://www.rondebruin.nl/copy4.htm > > -- > Regards Ron de Bruin > http://www.rondebruin.nl > > > > "SteveH" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > >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 65).> > > > 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 65 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 > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
How many worksheet s have the Master spreadsheet Steve ?
-- Regards Ron de Bruin http://www.rondebruin.nl "SteveH" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > 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 > > > Ron de Bruin wrote: >> Try this example Steve >> http://www.rondebruin.nl/copy4.htm >> >> -- >> Regards Ron de Bruin >> http://www.rondebruin.nl >> >> >> >> "SteveH" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... >> >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 65).>> > >> > 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 65 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 >> > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
24
Ron de Bruin wrote: > How many worksheet s have the Master spreadsheet Steve ? > > -- > Regards Ron de Bruin > http://www.rondebruin.nl > > > > "SteveH" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > > 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 > > > > > > Ron de Bruin wrote: > >> Try this example Steve > >> http://www.rondebruin.nl/copy4.htm > >> > >> -- > >> Regards Ron de Bruin > >> http://www.rondebruin.nl > >> > >> > >> > >> "SteveH" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > >> >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 65).> >> > > >> > 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 65 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 > >> > > > |
|
|
|
|
|||
|
Guest
Posts: n/a
|
I reply in your other thread with a example
-- Regards Ron de Bruin http://www.rondebruin.nl "SteveH" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... > 24 > Ron de Bruin wrote: >> How many worksheet s have the Master spreadsheet Steve ? >> >> -- >> Regards Ron de Bruin >> http://www.rondebruin.nl >> >> >> >> "SteveH" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... >> > 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 >> > >> > >> > Ron de Bruin wrote: >> >> Try this example Steve >> >> http://www.rondebruin.nl/copy4.htm >> >> >> >> -- >> >> Regards Ron de Bruin >> >> http://www.rondebruin.nl >> >> >> >> >> >> >> >> "SteveH" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)... >> >> >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 65).>> >> > >> >> > 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 65 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 >> >> > >> > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Creating new worksheets and appending data from multiple worksheets. | Dow | Microsoft Excel Programming | 5 | 11th Mar 2008 07:04 PM |
| copy data across worksheets and add multiple lines | madwoman | Microsoft Excel Programming | 0 | 13th Aug 2006 01:35 PM |
| Copy data in multiple worksheets | =?Utf-8?B?a2ZsZXRjaGI=?= | Microsoft Excel New Users | 2 | 11th Aug 2006 12:18 AM |
| Combining data from multiple worksheets and separate spreadsheets | =?Utf-8?B?a2ZsZXRjaGI=?= | Microsoft Excel Misc | 1 | 10th Aug 2006 07:53 PM |
| Copy only certain data from multiple worksheets | =?Utf-8?B?TWF0dA==?= | Microsoft Excel Misc | 0 | 10th Feb 2006 03:06 PM |
