Mar 27 2022 05:48 PM
Mar 28 2022 12:11 AM
@Fukesy73 First of all, which calendar template did you download? There are many different ones to be found on-line and most are notoriously difficult to adopt to ones own specific needs.
Secondly, it's probably not the most effective approach to have all co-workers in separate sheets with separate calendars for each of them. Wouldn't you want one list of all days off and show them all in one calendar?
Mar 28 2022 05:03 AM - edited Mar 28 2022 05:06 AM
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.
Mar 28 2022 06:14 AM
You wrote:
... 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.
....
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.
It made sense, back in the days of record keeping on paper, to have separate sheets for each person. Sadly, we often carry forward into the computer age the same mindset. It helps to recognize that Excel works well, and is easier to work with, if you put data like this into a single database (or table). I strongly suspect that's what @Riny_van_Eekelen was getting at with his comments.
Once you have a single database for all employees, you can (as you say in the second paragraph above)-- just identify each person with their names in a column headed "Name" or "Employee". And then have a separate sheet that extracts the desired info -- e.g., "how much time does Alan have left for vacation?" or if desired, other kinds of summary data, e.g., by department.
Mar 28 2022 06:27 AM - edited Mar 28 2022 06:28 AM
@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.
Mar 28 2022 07:24 AM