Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-30-2015, 06:15 AM
OfficeTemp99 OfficeTemp99 is offline Auto Incrementing source for data validation Windows XP Auto Incrementing source for data validation Office 2010 32bit
Novice
Auto Incrementing source for data validation
 
Join Date: Apr 2015
Posts: 3
OfficeTemp99 is on a distinguished road
Default 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
is the source range for the first placement. What I want is for it to change to
Code:
='New Sheet'!$B$2:$B$5
for the next row and so on, but I can't seem to make excel do this automatically. Is there any way to do this without manually selecting the range for each individual list?

Sorry if this isn't explained clearly, I'm very new to Excel and don't really know the proper lingo.
Reply With Quote
  #2  
Old 05-13-2015, 06:36 AM
gebobs gebobs is offline Auto Incrementing source for data validation Windows 7 64bit Auto Incrementing source for data validation Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Take out the dollar signs, at least from in front the row designations.

='New Sheet'!$A2:$A5
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Incrementing source for data validation 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
Auto Incrementing source for data validation 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft