Forum Discussion
Auto update from one sheet to another
0
I understand what you're saying. My spreadsheet only has the one calendar. For whatever reason the file is missing the calendar on my phone, but when I open it on the laptop, the calendar is there. So I can't screenshot it.
Anyways, the only reason I have a sheet dedicated for each of us, is so I can see what a person has left for vacation time.
Then the one calendar is at the end of the worksheet. So I was hoping to have each of our individual sheets input the workers names into the same calendar at the end.
I'll find out what calendar template I have, once I open my calendar.
I suppose I should just have one sheet, input all the dates that are booked off in, say, column A, and then put the person's name who booked it off, in column B. That way I just have to take info from one sheet, instead of several.
Fukesy73 This particular Calendar is not going to help you. It is just creating monthly calendar view that you can print out on paper and write notes on. The is no intelligence in this template that can dynamically list events. You would be better of by creating a list of your co-workers beginning balances and days planned/taken. You can the set-up some pivot tables to create the reports you need/want.
A very crude example of such a "system" is included in the attached file.
- Thanks so much. That table seems like a more simplified version, of the mess I was doing.
I was over-thinking it too much.
I went overboard because our automated payroll system wasn't working.
So a pivot table will allow me to put every employees name in, how much vacation time(hrs) each person has in total....and when I put the date in the table, it should calculate what they used and how much time they have left.