I want to apply a drop down bar to all cells that is linked to a list in a different tab. But when/if someone wants to add something to the list, i want them to just be able to add it and it automatically show up. I know you can just include more cells that are not in the list already but i dont want a huge drop down bar of all blanks.
Thanks!
You don't need to get a huge drop down LIST of all blanks.
You would use a dynamic range as the source.
Give us some more details and we'll show you how to do it.
Last edited by Tony Valko; 05-26-2016 at 02:06 PM.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Okay in my data sheet i have about 2000 lines of stuff and every time someone inputs their savings in the next available line they put their name. Most of the time it is the exact same people doing it so i want it to just be a drop down bar and for them to find their name so they are all "First Last" instead of using abbreviations and all that stuff.
In another tab i have a list of everyone's name that is included in the drop down list. if their name is not including i want them to just be able to go to the name list tab and write their name in and it show up in the drop down list automatically in the data tab.
From your other thread on this (that I closed, please dont post duplicate threads)
Originally Posted by FDibbins
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
Not really sure what that formula is doing...
sorry
Try this...
List of all names on Sheet2:
Data Range
New names will be added at the bottom of the list.
Data validation list to select a name is on Sheet1 in cell A1.
As the source for that list use:
=OFFSET(Sheet2!$A$2,,,COUNTA(Sheet2!$A$2:$A$100))
Adjust the end of range A100 as needed to allow for future name addition.
It worked. Thank you so much!
You're welcome. Thanks for the feedback!
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks