Hello,

I have learned much from the contributors here...many thanks.

Challenge:

To have one spreadsheet (master) trigger the populating of another
spreadsheet (sheet2) when data is entered into a cell on the master
sheet. Once certain data is entered into a cell on Sheet2, it would
populate data onto sheet3.


For example: When a date is entered into the "scheduled delivery date"
field, on the master sheet. I would like for this to "trigger" chosen
data to be entered into to the "delivery data sheet".

Once a delivery has been confirmed (by entering a date into the
delivered date field), this would trigger chosen data to be populated
into the "Pick up sheet".
Is this clear as mud?

Any comments would be welcomed.