Hello! I am trying to streamline tip tracking for a local restaurant. My goal is to have ONE data entry page that will fill the rest of the tabs.
Background: Employees take some tips home at the end of their shift AND are also owed tips (ie. if there isn't enough cash at the end of the night to cover all the credit card tips). I'd like to have one data entry page that lists what employees took home ("paid") and what they are "owed." The next sheet/tab would pull just the "owed" amount based on the employee name and the date. For example, if Jane was paid $10 and owed $40 on 3/3/2022, the 2nd sheet/tab would use "Jane-OWED" and "3/3/2022" to pull the value $40. Please see example spreadsheet attached for clarification.
I don't want to simply reference cells (ie. sum) because there is high turnover so we're constantly adding/removing employees which screws up the cell referencing.
THANK YOU!!!
Bookmarks