Hi,
I want to clone a drop down list from one sheet to another.
The value and functionality of both drop downs must be the same, and change accordingly if one of the two is changed.
How can I do this?
Hi,
I want to clone a drop down list from one sheet to another.
The value and functionality of both drop downs must be the same, and change accordingly if one of the two is changed.
How can I do this?
This requires VBA. Attached is an example of cloning two cells. See code in ThisWorkbook module:
Attachment reattached to remove password protectionPlease Login or Register to view this content.
Last edited by 6StringJazzer; 03-22-2021 at 03:06 PM.
6SJ.... It's password protected...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
I am sorry about that. It was leftover from something else I was working on. I reattached it in the same post.
Thank you 6StringJazzer!
Was hoping it could be done without vba, but will try your solution
I've tried the sample you gave me, when I select one of the options on sheet 1, it is also shown on sheet 2.
The other way around it doesn't work.
Is that right?
No, it's not right. I tested it both ways. I will check the file again.
I just tested it again and my file works both ways. I can provide a demo video if you are still having trouble.
Ok thank you, then I know the problem is at my end.
Will have to get better in vba
Is the problem in the file I gave you, or are you using it in a different file?
In your file. I will try it in my file to see what happens
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks