northernfrog
New member
- Local time
- Today, 07:52
- Joined
- May 11, 2008
- Messages
- 4
We're using a worksheet to schedule equipment maintenance and test periods by month based on either date of equipment purchase or last test.
Unprotected cells are limited to those where basic information is entered and there are a number of hidden columns used for schedule calculation. A copy of the schedule needs to be posted. Up until now this has been done in Word by entering the information in a table. We'd like to automate this process and be able to print a report from Excel.
The report would list the equipment with a scheduled test start date in the month to be printed. Each entry would contain equipment id, purchase date,
start and end dates, plus a couple of other columns not contained in the worksheet.
I know there has to be some type of year and month check. Perhaps from the month and date entered in a cell outside the print area or at the top of the report.
Also, there needs to be a formula that will locate the cells with 'start' and 'end' Beyond that I have no idea how to do this because the month columns can contain either both the start and end dates or only the start or end date.
Attached is a sample of the scheduler (with calculations removed) on Sheet2 and a sample of what the report should look like on Print. Any ideas or help would be appreciated.
Unprotected cells are limited to those where basic information is entered and there are a number of hidden columns used for schedule calculation. A copy of the schedule needs to be posted. Up until now this has been done in Word by entering the information in a table. We'd like to automate this process and be able to print a report from Excel.
The report would list the equipment with a scheduled test start date in the month to be printed. Each entry would contain equipment id, purchase date,
start and end dates, plus a couple of other columns not contained in the worksheet.
I know there has to be some type of year and month check. Perhaps from the month and date entered in a cell outside the print area or at the top of the report.
Also, there needs to be a formula that will locate the cells with 'start' and 'end' Beyond that I have no idea how to do this because the month columns can contain either both the start and end dates or only the start or end date.
Attached is a sample of the scheduler (with calculations removed) on Sheet2 and a sample of what the report should look like on Print. Any ideas or help would be appreciated.
