Hello. I’m new to this forum, so hopefully, I’m asking in the right place. Note: I can send a sample copy of the workbook if necessary (though I’m not sure where to post it).
Dilemma:
We have a “tracking” database for employee recogniion. This means that after someone (anyone) submits as card to recognize them for doing a good job, we record it. After the 5, 10, 15th card, they can receive a bronze, silver, or gold star pins to wear on their name badge (trust me, this is a big deal in our organization). We track according to the date the card was receievd, and we need a grand total of all cards for the month.
The first worksheet list all of our employees name, department, the date of each pin received an totals. The second tab has the monthly totals. Our secretaries do not want to swtich between tabs for the monthly total. They want a way to have the spreadsheet update automatically for the month. I’m sure seeing would be better than this description, so any help would be greatly appreciated. They’re ok with what I have, but I’m sure more could be done to the worksheet. Thanks in advance!
