Can you set up drop down list,l keeping pre existing data? My problem having 9000 rows of pre existing data without having had validation rules. If i set a dropdown List will this affect the current data if all 5 options is existing within the current data.
Last edited by FDibbins; 03-07-2021 at 02:22 AM.
Subject Heading should be Dropdown List not Lust
Last edited by Peledon; 03-04-2021 at 09:11 AM.
Made me laugh - but you can change it. It’s not a great title, anyway, so whilst you are at it, make it more descriptive, please .
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
thought it had been posted on the wrong site
Lol thank you. Was using ny phone and no glasses on
Have you got an answer after all that?
There is nothing magical about a drop down (data validation), it acts in the exact same way as if you had entered the data manually, and excel formulas only see the data in the cell as if it had been entered manually.
The only real advantages of using a DD is that it saves typing, avoids typos/spelling mistakes, restricts entry to what you specify, and maybe saves a bit of time in entering data.
Other than that, no difference to manual entry
So, that said, it should not affect existing data, as long as you dont try and edit any of that data
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks