populating sheets based on data from parent sheets

S

seve

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.
 
S

swisse

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
 
S

seve

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
 
Top