Hellow, I have an excel spreadsheet showing the following columns of data:
Project Number, Project Name, Project Owner, Project Auditor, Trip End Date, Turnover Date, and Project Due Date
I am trying to figure out how to auto populate an excel calendar (by month) to display the Project Number, Name, Owner, and Auditor by the date fields.
For example: Project Number: 1234, Project Name: XYZ, Project Owner: Bob, Project Auditor: Tom, Trip End Date: 1/31/14, Turn Over Date: 2/26/14, Project Due Date: 4/16/14
I would like to see the Project number, name, owner and auditor listed in a January calendar on 1/31/14 showing:
Trip End Date - BOB, 1234 XYZ - TOM
I would like to see the Project number, name, owner and auditor listed in a February calendar on 2/26/14 showing:
Turn Over Date - BOB, 1234 XYZ - TOM
I would like to see the Project number, name, owner and auditor listed in a April calendar on 4/16/14 showing:
Due Date - BOB, 1234 XYZ - TOM
Can this be done?
Thank you!
Bookmarks