Thanks in advance for any help on this. I'm using Excel 2003. (I have Access
2003 as well if that would help, make this easy.)
I have a simple template that helps employees count the cash in our two cash
registers. Simply put in the number of $20's, $10's, rolls of coins etc and
you get a total by till. Then the employee imputs the cash amount the
register thinks should be there and the result shows if the register is over
or under. There's a date/time field (using NOW()) and a drop down box for the
employees name.
Each time the template is used I want the employee name, the date/time, and
two of the totals for each till to go into a summary worksheet. Everyday we
count the till at least 3 times with different mgrs each time. Once the
template has updated the summary worksheet the template can close and clear
the data.
Suggestions?