I have looked and looked and really cannot find what I am looking for. Here is my dilemma... I have two worksheets on Excel 2010. On worksheet A, I have a list ** books Book A, Book B, Book C and so on. On each ** these books I have them numbered by how many copies I have. Book A has numbers 1, 2, and 3. Book B has numbers 1, 2 ans so on.
On worksheet B, I have where a person is listed that has "checked out" this book (like a library). Person #1 has "checked out" book A #1 and book B #1 . Person #2 has "checked out" book A #2 and book C #4 ...
I have used data validation drop down list on the book titles on one cell and then did a indirect function drop down list for their numbers on another cell. What I am needing is a way to make the numbers on the 2nd drop down list either flag that the number ** the book was already chosen by a person or disappear from the list when selected.
I am not very good at excel and only know a few basics. Could someone please help.
Thanks!!
Bookmarks