dragonmouse
Board Regular
- Joined
- May 14, 2008
- Messages
- 129
- Office Version
- 2016
- Platform
- Windows
QUESTION: I'm doing a preventative maintenance spreadsheet. When I complete a task on a particular date, I put the date in that I've completed it in column "B" (for example) and a new "due date" appears in column "B". Is there a way to keep a record on another worksheet that will maintain a history of my completions?
Example: I have a battery that needs its terminals cleaned every 3 months and a full charge every 6 months. I want to see when the new task is due and I want a HISTORY of all the dates I completed the task on separate sheet. I will also have other equipment to track such as a speaker or a capacitor (just making up widgets). I've successfully made my WORKSHEET. But I don't know if EXCEL can do a HISTORY SHEET. PLEASE offer suggestons or let me know if it's possible.
<colgroup><col width="109" style="width: 82pt; mso-width-source: userset; mso-width-alt: 3986;">
<col width="84" style="width: 63pt; mso-width-source: userset; mso-width-alt: 3072;" span="3">
<col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;">
<col width="69" style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;" span="2">
<col width="64" style="width: 48pt;" span="2">
<col width="70" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;">
<tbody>
</tbody>
Example: I have a battery that needs its terminals cleaned every 3 months and a full charge every 6 months. I want to see when the new task is due and I want a HISTORY of all the dates I completed the task on separate sheet. I will also have other equipment to track such as a speaker or a capacitor (just making up widgets). I've successfully made my WORKSHEET. But I don't know if EXCEL can do a HISTORY SHEET. PLEASE offer suggestons or let me know if it's possible.
WORKSHEET 1 | |||||||||
PRODUCT | FREQ | COMP | DUE | FREQ | COMP | DUE | FREQ | COMP | DUE |
BATTERY | 90 | 30-Aug-19 | 28-Nov-19 | 180 | 1-Jun-19 | 28-Nov-19 | |||
SPEAKER | 60 | 30-Aug-19 | 29-Oct-19 | ||||||
CAPICITOR | 180 | 1-Jan-19 | 30-Jun-19 | ||||||
HISTORY | WORKSHEET | ||||||||
60 | 90 | 180 | |||||||
BATTERY | 30-Aug-19 | 1-Jun-19 | |||||||
BATTERY | 1-Jun-19 | 3-Dec-18 | |||||||
BATTERY | 3-Mar-19 | 6-Jun-18 | |||||||
BATTERY | 3-Dec-18 | 8-Dec-17 | |||||||
BATTERY | 4-Sep-18 | 11-Jun-17 | |||||||
BATTERY | 6-Jun-18 | ||||||||
BATTERY | 8-Mar-18 | ||||||||
BATTERY | 8-Dec-17 | ||||||||
BATTERY | 9-Sep-17 | <START DATE> | |||||||
SPEAKER | 30-Aug-19 | ||||||||
SPEAKER | 1-Jul-19 | ||||||||
SPEAKER | 2-May-19 | <START DATE> | |||||||
CAPICITOR | 3-Mar-19 | ||||||||