Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
How do I plot data by drilling down through sheets? | Charts and Charting in Excel | |||
Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
populating data from excel into access | Links and Linking in Excel | |||
How do I plot data in Excel that is captured on separate sheets; . | Excel Discussion (Misc queries) |