This is what I want to do. I want to basically keep a chart of what everybody in my office has logged out on their ID.
I keep all the volume requests in a column titled "Volume Requests" which covers cells A159 to A172.
This is an example of a volume request:
100 Main Street 100334111 (9999A) GH
The "Results" cells are from B159 to B172, for example who put what volume request on their ID.
Usually what I would put in the cell is "Found - X00001", the X00001 represents the person's ID number.
On another page, I have everybody's ID number listed going down in column A.
Columns B, C, D, E, and F represents what they have on their ID, everybody can get 5 things on their ID max, so each row is six spaces - the ID number plus the 5 things allotted.
Is there a way for me have a macro that automatically translates what volume was found to keep my list update of what's on who's ID so that I dont have to do it manually?
I've included screen shots. This is what a volume request on my sheet looks like below:
Capture4.PNG
This is how I want to automatically show on the part of the sheet that has everybody's ID listed:
Capture5.PNG
Any idea on how to do this?
Bookmarks