Hi Excel World,
I am presently trying to make an interactive employee tracker to track employee time off, birthdays, and work aniversaries. I am not a fan of using the all 30 days for each month across a spread sheet. I put in drop down lists for employees names, type of day off, etc. I want to put in a vlookup or something at the bottom to lookup all the days off for one employee. I would also like to track when I have received each employees time sheet so I know who has not submitted them yet.
I love excel and have done some of the medium to advanced things in the past but I have only done them once here and there as needed. I am not an expert. I am interested in what other excel users might be using or any helpful tips. I realize this might be a step by srep project that may take me awhile. Any help or advice would be greatly appreciated.
I am presently trying to make an interactive employee tracker to track employee time off, birthdays, and work aniversaries. I am not a fan of using the all 30 days for each month across a spread sheet. I put in drop down lists for employees names, type of day off, etc. I want to put in a vlookup or something at the bottom to lookup all the days off for one employee. I would also like to track when I have received each employees time sheet so I know who has not submitted them yet.
I love excel and have done some of the medium to advanced things in the past but I have only done them once here and there as needed. I am not an expert. I am interested in what other excel users might be using or any helpful tips. I realize this might be a step by srep project that may take me awhile. Any help or advice would be greatly appreciated.