|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
July 10th 12, 03:02 AM
|
|||
|
|||
Using Data Validation in a Table
Hi. I have recently discovered the usefulness of tables in Excel 2010. However I have come up with a problem, which I am sure has a solution.
I am using a table in which I would like to be able to select the data input for one column from a list. I have created the list on another sheet, and used the data validation tool to select the data succesfully in the table. However when I add a row by using tab at the end of the last row, a new row is inserted into the table, with all the formulas updated, but the data validation for the column does not get copied to the new row. Is there any way of doing this automatically without using VBA? 
|
| Ads |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using Table Column for Data Validation List | keith | Excel Discussion (Misc queries) | 8 | October 9th 10 10:10 PM |
| Validation Data using Validation Table cell range..... | Dermot | Excel Discussion (Misc queries) | 16 | January 5th 10 09:35 PM |
| Data Validation using a table | JBranter | Excel Worksheet Functions | 3 | April 15th 09 06:09 PM |
| Data validation list from table | Jon[_2_] | Excel Worksheet Functions | 6 | April 29th 08 09:53 PM |
| Data Validation with multiple table selection | SteveMax | Excel Discussion (Misc queries) | 3 | May 11th 07 02:49 PM |
Linear Mode
