Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating worksheets from master worksheet based on column value
I am trying to save data in target worksheets based on column value of cell
found in source(Master) spreadsheet. I know I can consolidate several spreadsheets into one master but I want to do it the other way by having one master and having it update multiple spreadsheets based on colum value on Master. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating worksheets from master worksheet based on column value
Here's a non-array formulas set-up which can deliver the desired functionality
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, w/o any intervening blank lines. 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. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "NBROWN" wrote: I am trying to save data in target worksheets based on column value of cell found in source(Master) spreadsheet. I know I can consolidate several spreadsheets into one master but I want to do it the other way by having one master and having it update multiple spreadsheets based on colum value on Master. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating worksheets from master worksheet based on column valu
Max,
Thank you....That worked for me beautifully.... "Max" wrote: Here's a non-array formulas set-up which can deliver the desired functionality 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, w/o any intervening blank lines. 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. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "NBROWN" wrote: I am trying to save data in target worksheets based on column value of cell found in source(Master) spreadsheet. I know I can consolidate several spreadsheets into one master but I want to do it the other way by having one master and having it update multiple spreadsheets based on colum value on Master. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating worksheets from master worksheet based on column valu
welcome, good to hear that.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "NBROWN" wrote in message ... Max, Thank you....That worked for me beautifully.... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating worksheets from master worksheet based on column valu
Hey there Max you seem to be on top of things.
I need to update several other idividual spreadsheets from my master sheet. ie. if i should type a project in text under Joe's name upon saving or clicking away this update must go to his sheet on his computer and automatically update what I typed. "Max" wrote: welcome, good to hear that. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "NBROWN" wrote in message ... Max, Thank you....That worked for me beautifully.... |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Updating worksheets from master worksheet based on column valu
Your tip did work so far but there is one more thing ; -
Formula works, except what we need is that whenever data is changed in sheets Red, yellow or Green (individually) then that data is also updated into the WS1 sheet. Thank you "Markv" wrote: Hey there Max you seem to be on top of things. I need to update several other idividual spreadsheets from my master sheet. ie. if i should type a project in text under Joe's name upon saving or clicking away this update must go to his sheet on his computer and automatically update what I typed. "Max" wrote: welcome, good to hear that. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "NBROWN" wrote in message ... Max, Thank you....That worked for me beautifully.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I generate lists in worksheets based on a master list works | Excel Worksheet Functions | |||
Updating Sublists from Master worksheets | New Users to Excel | |||
Automatically updating worksheets from a master worksheet | Excel Worksheet Functions | |||
Populate worksheets based on a master sheet | Excel Worksheet Functions | |||
Create a master worksheet based on 2 different worksheets | Excel Worksheet Functions |