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.

It would be best to have in Column A of Master Sheet a key value, in other words a unique control number for each delivery, to be used consistently in Column A on sheets 2 and 3 for events associated with that delivery.

Sheet 2 Column A would just be a reference to Master Column A. Other Sheet 2 columns would be lookup formulas.

Example: 5 deliveries so far Master Sheet. In Column A,

0001
0002
0003
0004
0005

With appropriate data in Columns B, C, etc.

Sheet 2 Cell A2: =Master!A2. Drag down.

Sheet 2 Cell B2, C2, etc. =VLOOKUP($A2,Range,ColumnNum,FALSE). Drag down.

Range= the data range on Master Sheet.

ColumnNum= the column number in "Range" of the data you want to retrieve.

Likewise for Sheet 3 to Sheet 2.

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