Maintaining Historical Data

[dragonmouse]

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.

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

<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>

 

[dragonmouse]

bump