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?