I have a tip sheet for various employees that I tabulate on one sheet for everybody together for our end of night reports. The top section (see attached pictures) are for customer counts and the bottom section is for the tips from each of those customers. My business partner still wants the full sheet but also wanted separate sheets for each employee, which I have set up. I have tried various excel groups trying to figure out how to get the data from the MAIN sheet to copy over to each employee as it is entered but with no success. Is there a solution that I can find here to get this to work? Currently I just copy and paste from the main sheet which is a tedious task.
PROBLEM: Would like to enter data in the MAIN sheet cells where the information (along with the sums) copy over to a separately named sheet that correlates with that person from the MAIN sheet.
Bookmarks