Not sure really how to explain this, but here is what I'm trying to accomplish. I'm working on a spreadsheet that will act as a live inventory tracker and accountability checklist. I want to be able to sort items via choices in drop down boxes and also to do a final list of all items that do not have a check mark next to them.
So the main page would be a master list. The item should stay on this list at all times unless removed by the user. Depending on the drop box for the storage location would put the item on a new page that i would name via the storage areas. I was wondering if it could be done automatically but if not assigned to a macro button for sorting.
Quick example of idea
page 1 = master list page 2 = cage 1 page 3 = cage 2
list of the items all listed on the master list, a column in the master page will have a drop down list with the item storage areas available. When the selected item is selected via drop down box it would then be sorted onto the correct page. All items would still stay on the master list.
The master list would also have a column with a checkbox or yes /no depending on how it works and when a person is doing an inventory any item not found would be flagged and placed on another page.
On the individual pages the items would be sorted from top to bottom, no empty spaces. if an item was moved from a storage area from cage 1 to cage 2 on the master list it would be removed from the wrong storage area and placed into the correct storage area when sorted.
thanks for any help
Bookmarks