Faced with a rather daunting challenge and looking for suggestions.
Have a task to code that involves the following:
1) 30 samples
2) each sample has 3 replicates
For each replicate, 1 of 96 'locations' must be selected. Once a location has been selected, it needs to be removed from options offered to other replicates. If a selection is deleted, it should then be made available to other replicates for selection.
Was thinking of possibly maintaining a string variable in VBA that contains available selections in a dynamic list that would feed data validation drop-downs.
As the selections/assignments are made, need to maintain a grid of sorts that shows 'location' selected for each sample/replicate.
Any suggestions on how to do this? Open to any and all suggestions of other possible ways to handle this as well.
Have a task to code that involves the following:
1) 30 samples
2) each sample has 3 replicates
For each replicate, 1 of 96 'locations' must be selected. Once a location has been selected, it needs to be removed from options offered to other replicates. If a selection is deleted, it should then be made available to other replicates for selection.
Was thinking of possibly maintaining a string variable in VBA that contains available selections in a dynamic list that would feed data validation drop-downs.
As the selections/assignments are made, need to maintain a grid of sorts that shows 'location' selected for each sample/replicate.
Any suggestions on how to do this? Open to any and all suggestions of other possible ways to handle this as well.
