I need to create a worksheet that has dropdown lists based off of predetermined options once selected shows only valid choices in the next column. For instance, I would need a list of genes in the B column that a user can pick from. Once a gene is selected from that list, it will bring up only the valid choices for that gene to choose from in column C. Like shown below. Currently this is being done without macros and cannot be input with numbers in the beginning, so RS was added to make it work (preferrebly without the RS to streamline with the databases and other applications).
Gene DAS.025 would have (3) analyses to choose from in column C: RS_1, RS_2, or RS_3.
Gene / Analyses
DAS.025 - RS_1, RS_2, RS_3
SYN.222 - RS_A, RS_A
MON.123 - RS_B1
What would be ideal is if there was a place in sheet one to input new genes and analyses without having to manually add them to the end of the list on sheet 2. An empty field to input new info for each in sheet one is the hope. Along with the input fields, an auto-sort, ascending in the gene column would be needed too. I have attached a copy having the extent of my Excel knowledge. Without a macro this would not have any security to prevent a user from deleting or messing with the current table schema in both sheets. There are going to be duplicates of genes and analyses added all the time. This worksheet is to track work that is done in hopes of increasing productivity.
Overview:
Column B and C lists needed. C list is based off of what is chosen in B. Column B would need to be sorted by ascending automatically. A field to add to column B and a field to add to column C as new genes and analyses are needed.
Not sure if this is possible, but an entry field for users that would insert a new line with date, gene, analysis, J#, Plate#, Reps, Reason, etc... by just inputting each columns data on a stationary row, like the empty field needed for additions to the lists.
Any help, guidance, or anything would be much appreciated.
Please let me know if I am unclear on anything and I would love to elaborate.
Thanks again.
Bookmarks