Using Data Validation in a Table

D

DovkaM

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 dat
input for one column from a list. I have created the list on anothe
sheet, and used the data validation tool to select the data succesfull
in the table. However when I add a row by using tab at the end of th
last row, a new row is inserted into the table, with all the formula
updated, but the data validation for the column does not get copied t
the new row. Is there any way of doing this automatically without usin
VBA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Sorting Multiple Tables 1
Setting column width in a table with a macro is not working 0
Creating a Search using a combo box and then creating a report. 4
Need Help with a VBA subroutine 0
Data Validation "The Source Currently Contains an Error" 0
Create a chart from a table in word thats dynamic 0
Repeating a row other than the 1st row as the header row in a table from next page 1

Top