I have just started using Excel and my boss wants me to create a Job Calendar. I have an Excel sheet with a column for Job #'s and Columns for Start & End Dates. He wants to be able to add the start & end dates to the spreadsheet and then setup a sheet for each month and the program to look up the start and end dates and place the corresponding Job # on those dates. Is this possible in excel?
Bookmarks