Spreadsheet to track cards given out

[Jade2013]

Sheet 1
WORKERS NAME CARD NUMBER
Bob 10

Sheet 2
Management: Issued Cards
Fred 1 2 3 4 5 6 7 8 9 10


Sheet 3
Management: "Total Cards Issued:" "Total Cards Given Out"
Fred 10 ???????

Hello,

I am not that well at excel and am looking for a little help. I am trying to do a spreadsheet so that when I recieve a card I enter the card number into "Sheet 1", when entered it will then search "Sheet 2" to find the name associated with that number. Then I want it to update "Total Cards Given Out" in "Sheet 3". This is to keep track of how many "Token cards" managers have given out to workers. Can anyone give me a hand with this please?

Thanks!

[alansidman]

While you have shown what you want, working with real data or dummy data will make it easier to provide a usable answer.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic