| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I use existing data from a worksheet to auto fill a second
I am stumped, I want to use data generated on sheet 1 via drop down lists to
automatically fill in data on subsequent sheets. I also need the data on the subsequent sheets to recognize the value of ariginal data and fill accordingly. For example Sheet 1 cell A1 = drop down list of maple, oak, or alder cell A2 = drop down list of styleA, styleB, or styleC Sheet 2 cell A1 = model number corresponding to A1+A2 cells from sheet 1 ie(sheet 1 A1 maple was selected, A2 styleA was selected then on sheet 2 cell A1 maple styleA is automatically filled in) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto fill form from a worksheet | Excel Discussion (Misc queries) | |||
| How to auto populate an invoice from data in an existing worksheet | Excel Discussion (Misc queries) | |||
| auto fill entered data from one worksheet to another | Excel Discussion (Misc queries) | |||
| How do I use auto fill to add information from an existing source? | New Users to Excel | |||
| Auto fill for data from another worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
