Dynamic drop down list...
Dear Experts,
Greetings!
I have a query regarding the "Drop down list".
I am trying to develop the dynamic drop down list.
The drop down list must be updated automatically when data rang increased.
I have attached herewith the "Book 6" as example for your kind reference.
How to develop it? using formula or VBA code? please guide.
Thanks in advance...
Hi
You need to create a dynamic named range for column A for usung in your validation list.
This is one formula that does it.
Formula:
=OFFSET(Sheet1!$A$2;0;0;COUNTA(Sheet1!$A:$A)-1;1)
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Dear Fotis1991,Originally Posted by Fotis1991
Hi
You need to create a dynamic named range for column A for usung in your validation list.
This is one formula that does it.
Formula:=OFFSET(Sheet1!$A$2;0;0;COUNTA(Sheet1!$A:$A)-1;1)
Thank you very much for the help.
The offset formula works nicely and up to my expectation.
Thanks again.....
You are welcome and thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks