Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to enter data in one form & populate several others w/same.
Is there a way to create a form where you enter data in a parent field and it
populates several "children" forms? For example, paperwork in clinical setting. Child forms have individual client info. Parent form is where data applicable to all can be entered and populated in children to avoid retyping or repetitive cut and paste. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to enter data in one form & populate several others w/same.
Perhaps a close fit ..
Try this sample construct from my archives: http://www.savefile.com/files/151988 AutoCopy_Data_To_Resp_Sheet_Non_Array_Approach.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 "Colours" col, which may contain eg: Red, Yellow, Green, etc. All lines with "Red" in the key col will be auto-copied to the sheet named: Red, and appear neatly bunched at the top. Ditto for lines with "Yellow", "Green", etc. Propagation of the "child" sheet is as simple as making a copy of the initial one, then renaming it accordingly as the key col value. Eg we first formulate one child sheet for "Red", dress it up nicely, then just make copies of the "Red" sheet, and rename these as: Yellow, Green, etc -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "cmcpsych" wrote: Is there a way to create a form where you enter data in a parent field and it populates several "children" forms? For example, paperwork in clinical setting. Child forms have individual client info. Parent form is where data applicable to all can be entered and populated in children to avoid retyping or repetitive cut and paste. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to enter data in one form & populate several others w/same
Thank you Max. A very close fit indeed! Brilliant!
Christina "Max" wrote: Perhaps a close fit .. Try this sample construct from my archives: http://www.savefile.com/files/151988 AutoCopy_Data_To_Resp_Sheet_Non_Array_Approach.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 "Colours" col, which may contain eg: Red, Yellow, Green, etc. All lines with "Red" in the key col will be auto-copied to the sheet named: Red, and appear neatly bunched at the top. Ditto for lines with "Yellow", "Green", etc. Propagation of the "child" sheet is as simple as making a copy of the initial one, then renaming it accordingly as the key col value. Eg we first formulate one child sheet for "Red", dress it up nicely, then just make copies of the "Red" sheet, and rename these as: Yellow, Green, etc -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "cmcpsych" wrote: Is there a way to create a form where you enter data in a parent field and it populates several "children" forms? For example, paperwork in clinical setting. Child forms have individual client info. Parent form is where data applicable to all can be entered and populated in children to avoid retyping or repetitive cut and paste. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to enter data in one form & populate several others w/same
Glad you found it useful, Christina !
Thanks for the feedback .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "cmcpsych" wrote in message ... Thank you Max. A very close fit indeed! Brilliant! Christina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Baffling! Spreadsheet Data Form Size | Excel Discussion (Misc queries) | |||
Pleeze Help! Export Excel data into a form in a Word Doc...this one's tough! | Excel Discussion (Misc queries) | |||
Data Entry Form and List | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
form to enter Silent Auction data? | Excel Discussion (Misc queries) |