Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Validation
Hello,
I am using Excel 2003 with Windows XP. I have a cell on a worksheet that has a data validation list with the numbers 3-10. The numbers are stored directly in the cell. Underneath this cell I have a table which is, to start with, 3 columns wide by X rows tall. How can I adapt this sheet, so that if a user selects,say 5 from the validation drop down cell, the table underneath automatically expands to 5 columns. If the number 3 is chosen, the table reduces to 3 columns. Thanks in advance for your help. Regards, Ket London, UK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation lists | Excel Discussion (Misc queries) | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Data validation | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions |