#1
|
|||
|
|||
Auto Incrementing source for data validation
Greetings! I am currently fixing up a spreadsheet which contains work experience placements for my organisation. My supervisor would like a column for "List of Duties" for each placement, however just typing out the information would make the rows/columns very large. So we came up with the idea of putting the duties in a drop down menu simply for the sake of taking up less space.
I have created a new, separate sheet to input the duties and then use these cells as the source for the list via Data Validation. The only problem is, when I drag the cell down, the source does not auto increment, giving all the work placements the list of duties from the first one. Code:
='New Sheet'!$A$2:$A$5 Code:
='New Sheet'!$B$2:$B$5 Sorry if this isn't explained clearly, I'm very new to Excel and don't really know the proper lingo. |
#2
|
|||
|
|||
Take out the dollar signs, at least from in front the row designations.
='New Sheet'!$A2:$A5 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
data validation from another sheet | paulys | Excel | 1 | 06-30-2014 01:40 AM |
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
Data Validation drop down | rkalapura | Excel | 1 | 05-27-2012 02:23 AM |
If/then formulas with data validation | shira47 | Excel | 1 | 04-09-2012 05:14 AM |
Data validation with IF | Klyxrastafari | Excel | 1 | 10-03-2011 04:41 PM |