Auto Incrementing source for data validation

		Microsoft Office Forums > Microsoft Excel > Excel
Auto Incrementing source for data validation

05-13-2015, 06:36 AM

gebobs

Windows 7 64bit Auto Incrementing source for data validation

Office 2010 64bit

Expert

Join Date: Mar 2014

Location: Atlanta

Posts: 837

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:18 PM.