ok... lets try this forum... i seem to be having trouble explaining what i need.
I have a workbook "book1" where users will be entering ID's of containers. when they enter it will look like so
12-1
15-5
30-2... and so on (12 maximum for now)
I have another workbook "book2" that im trying to use to keep track of container usage so each time the container hits 10 uses we will know and can clean it.
so the other workbook will have the list of ALL the containers we have and then a count on times it was used
12-1 5
12-2 10
12-3 2
im not sure how to go about this... but each time a user enters the ID's of the containers they are currently using in book 1 i need a button macro for it to update the usage count for that container in book2 by +1 ... when a user enters the container ID's there wont be any kind of order, so it needs to somehow find the corresponding container ID on the big list and then update the count usage
any takers?
I have a workbook "book1" where users will be entering ID's of containers. when they enter it will look like so
12-1
15-5
30-2... and so on (12 maximum for now)
I have another workbook "book2" that im trying to use to keep track of container usage so each time the container hits 10 uses we will know and can clean it.
so the other workbook will have the list of ALL the containers we have and then a count on times it was used
12-1 5
12-2 10
12-3 2
im not sure how to go about this... but each time a user enters the ID's of the containers they are currently using in book 1 i need a button macro for it to update the usage count for that container in book2 by +1 ... when a user enters the container ID's there wont be any kind of order, so it needs to somehow find the corresponding container ID on the big list and then update the count usage
any takers?
