Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy cells to specific sheets
Hi all
I am trying to find a function that will copy 4 adjacent cells to another sheet within the same workbook and place them at the next empty row in the required sheet. I have one master sheet and wish to copy specific data based on a user id to that users worksheet. Three sheets named Master, Person 1, Person 2. Excel 2007 and Vista Home premium. All help will be very much appreciated Double R |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy cells to specific sheets
Here's one formulas set-up which delivers it the way you want ..
Take this sample construct from my archives: http://www.savefile.com/files/430142 AutoCopy Lines to Resp Sht Non Array.xls (Full details inside, nicely rendered. Easy to adapt ..) Data is continuously entered in a master ("parent") sheet, with lines neatly auto-copied to each individual ("child") sheet based on the values within a key col. In the sample, the key col in the master sheet is the "State" col, which may contain eg: NY, CA, NV, SD, AZ, etc. All lines with "NY" in the key col will be auto-copied to the sheet named: NY, and appear neatly bunched at the top. Ditto for lines with "CA", "NV", etc which will be copied into their respective sheets. Propagation of the "child" sheet is as simple as making a copy of the initial one, then renaming it accordingly as the next key col value. Eg we first formulate one child sheet for "NY", dress it up nicely, then just make copies of the "NY" sheet, and rename these as: CA, NV, SD, etc. In your case, the key col would be your "UserID" col, eg: UserID1, UserID2 etc -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Double R" wrote: Hi all I am trying to find a function that will copy 4 adjacent cells to another sheet within the same workbook and place them at the next empty row in the required sheet. I have one master sheet and wish to copy specific data based on a user id to that users worksheet. Three sheets named Master, Person 1, Person 2. Excel 2007 and Vista Home premium. All help will be very much appreciated Double R |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy cells to specific sheets
Thanks very much Max, I will have a look at it and se if I can adapt it to
my needs, but it will be next weekend before I get time Thanks once again for your reply and solution Double R "Max" wrote in message ... Here's one formulas set-up which delivers it the way you want .. Take this sample construct from my archives: http://www.savefile.com/files/430142 AutoCopy Lines to Resp Sht Non Array.xls (Full details inside, nicely rendered. Easy to adapt ..) Data is continuously entered in a master ("parent") sheet, with lines neatly auto-copied to each individual ("child") sheet based on the values within a key col. In the sample, the key col in the master sheet is the "State" col, which may contain eg: NY, CA, NV, SD, AZ, etc. All lines with "NY" in the key col will be auto-copied to the sheet named: NY, and appear neatly bunched at the top. Ditto for lines with "CA", "NV", etc which will be copied into their respective sheets. Propagation of the "child" sheet is as simple as making a copy of the initial one, then renaming it accordingly as the next key col value. Eg we first formulate one child sheet for "NY", dress it up nicely, then just make copies of the "NY" sheet, and rename these as: CA, NV, SD, etc. In your case, the key col would be your "UserID" col, eg: UserID1, UserID2 etc -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Double R" wrote: Hi all I am trying to find a function that will copy 4 adjacent cells to another sheet within the same workbook and place them at the next empty row in the required sheet. I have one master sheet and wish to copy specific data based on a user id to that users worksheet. Three sheets named Master, Person 1, Person 2. Excel 2007 and Vista Home premium. All help will be very much appreciated Double R |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy cells to specific sheets
welcome, Double R. Thanks for posting back.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Double R" wrote in message ... Thanks very much Max, I will have a look at it and se if I can adapt it to my needs, but it will be next weekend before I get time Thanks once again for your reply and solution |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic deletion of specific cells from multiple sheets | Excel Worksheet Functions | |||
Copy cells from one worksheet and paste to incrementing sheets? | Excel Discussion (Misc queries) | |||
Adding numbers from specific cells in a number of sheets | Excel Worksheet Functions | |||
Macro to copy specific cells from one workbook to another | Excel Discussion (Misc queries) | |||
in VBA Sheets("mysheet").Copy Befo=Sheets(1) how do i get a reference to the newly created copy of this sheet? | Excel Worksheet Functions |