populating sheets based on data from parent sheets
 

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.

Let's say you have 2 sheets in your workbook. In sheet2 put this formula in
cell A1:
=IF(ISBLANK(Sheet1!A1);"";Sheet1!A1)
In sheet1cell A1 put some number or text, press Enter, go back to sheet2 and
check if it copied what you wrote in A1.

Swisse

Thank you swisse,

I should have mentioned that I was using

=IF(master!$P2=0,"",+master!H2)

which, like your suggestion gets the job done but I have to resort
sheet2 to get the blanks out.

I'd prefer a solution that would add a row of data in sheet2 when the
criteria was met in the master sheet, without having to copy and paste
formulas and sorting data.

Thanks again,

Steve

swisse wrote:
Let's say you have 2 sheets in your workbook. In sheet2 put this
formula in
cell A1:
=IF(ISBLANK(Sheet1!A1);"";Sheet1!A1)
In sheet1cell A1 put some number or text, press Enter, go back to
sheet2 and
check if it copied what you wrote in A1.

Swisse