Hi All,
The Company I work for does projects all over the world and my boss has asked me to have a spreadsheet to track the travel of everybody. Now he's asking me to add a calendar too so he can easily locate where everyone is in case they're needed elsewhere. Since it's not something that's always set in stone in the future, I have created a somewhat automatic calendar, but I am looking for a way to automatically populate with the country or at least highlight the date whenever someone is travelling from my data sheet.
Any help would be greatly appreciated!
I was trying to upload my file but I can't since this is my first time posting so I will try and describe them as much as I can:
Travel data sheet:
(starting on A1)
I have in this sheet from Columns A thru H the following
A- Program (name)
B- Project (name)
C - Location (Country)
D - Travel Start Date (date)
E - Travel End Date (date)
F - Total Days (formula calculating amount of days between both dates
G - Trip Purpose (Title of trip)
H - Traveler (Employee Name)
Whenever there is more than one traveler on the trip, the trip is duplicated on a another row with the other name
Calendar Sheet--
I have in this sheet from Columns A thru AF the following
(starting on Cell A7)
A - Traveler (list of travelers the company has)
B - Job title (VLOOKUP from another sheet)
C thru AF - Calendar by days (01/01/2019, 01/02/2019 etc...)
thank you in advance!
Bookmarks