Hi there,
Sheet A: I have a database of samples which are all uniquely coded in column A. In column B it describes an integer for which box (IRL) the samples are stored in. In column C I have a Yes/No for whether the samples have been processed or not.
Sheet B: I have a summary of what IDs are in each box. so a row describes a box number and then a range of values for the IDs. I have been able to figure out how to get it to tell me the NUMBER of samples which have been processed (ie yes/no). I also need a dropdown menu that gives me the list of IDs (Sheet A) that meet the conditions of box (x) and processed no.
I also would like this to live update so that when I go into Sheet A and say that I have processed this sample, it will automatically shorten the list in the dropdown menu.
Any ideas? Please be gentle, I'm not a very experienced excel user...
Also, I am using Excel 2010.
Thank you!
Bookmarks