Hi,
I want to make a dropdown list for column D in sheet1 and that list comes from column M6 to unknown last row in column M in sheet2.
In the data validation, i don't know how to write a formula because the last row is changing.
Any advice appreciated.
Thanks
Create a dynamic named range:
http://www.excel-easy.com/examples/d...med-range.html
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Thanks, it worked.
In columnD in sheet1, I want to have the dropdown list, but I don't know the last row because the last row in column D is changing.
How can I have the dropdown list in column D ?
Thanks
The countA portion of the offset finds the last row for you, assuming it is all contiguous data.
Yes, in sheet 2, but how about sheet 1?
I want to add the data validation for until last row in column D in sheet 1.
Thanks
Does the same type of solution not apply?
I dont understand what is different about sheet1 and why the link above does not work for you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks