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.

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.

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.

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