

March 10, 2016

I apologize for the unclear writing, I speak Hebrew and use Google translation.
I'll try to explain it more accurately -
In the attachment - when you see a cell in column A, a drop-down list of cities appears
And this is excellent for me to my file
My problem is that it works only in column A
And I need it to work for me either in column C or any other column?
The question is how to do it?
Thank you very much for your response!
Leah


October 5, 2010

Hi Lea,
No problem. It sounds like you need to use a data validation list. I can see there's some VBA in the workbook but you don't need any of that with the DV list.
Check out that blog post and see if you can implement what you need.
Regards
Phil


October 5, 2010

Hi Lea,
I now realise this is the same qs you asked in the General Qs & Answers and Mynda replied telling you that Data Validation lists was the solution too.
Please don't ask the same question more than once. Mynda and I have both spent time on this now to give you the same answer.
Phil
1 Guest(s)
