Assuming your data start in sheet1!A1
Create a defined name range call MyRange
=Sheet1!$A$1:INDEX(Sheet1!$A:$A,COUNTA(Sheet1!$A:$A))
Validation
Allow: select List
Source: =MyRange
Assuming your data start in sheet1!A1
Create a defined name range call MyRange
=Sheet1!$A$1:INDEX(Sheet1!$A:$A,COUNTA(Sheet1!$A:$A))
Validation
Allow: select List
Source: =MyRange
Hi, could you explain on how to create the range again? I don't quite get the define part. I have attached a sample of my working worksheet.
Last edited by shg; 07-06-2010 at 11:39 PM. Reason: deleted quote
Lewis, please don't quote whole posts.
Entia non sunt multiplicanda sine necessitate
oh, I'm sorry.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks