| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
list from empty data cell source
I have 2 sheets. I would like Sheet 1 A1 to have a list from items in Sheet
2 A1:100. The only problem is, Sheet2 A1:100 starts off blank until there are items listed later. For example, Sheet1 A1:100 "WILL" contain a list of cars. This list will continuously be added to on a daily basis. I would like to click on Sheet2 A:1 and be able to select from a list of cars that we have so far. How can I do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get rid of empty cells when displaying Data validation list | Excel Discussion (Misc queries) | |||
| compile list in 1st empty cell | Excel Discussion (Misc queries) | |||
| cell auto population - why 0 when source cell is empty? | Excel Discussion (Misc queries) | |||
| Creating a summary list from source data - can you?? | Excel Discussion (Misc queries) | |||
| mail merge- & data source - only taking 1st name in the list | Excel Discussion (Misc queries) | |||
Threaded Mode
