Maintenance Log

[Legacy 436357]

Hello,

I have received some fantastic help so far and I appreciate the lessons.

I am trying to apply copy and pasting rows with code for my new application but no success yet.

What I would like to do is copy the checked maintenance row from Sheet1 to the end of the table in Sheet2 then clear the check boxes and update the 'Last Date' and 'Last O/D' on Sheet1.

Is this possible with one macro?

Thank you very much in advance for your help.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	Vehicle		Date	Odometer	Performed By
2	2001 Ford F150		10/17/2018	70000	Walmart
3
4	Last Date	Last O/D	New Date	New O/D	Maintenance Performed	Months	Miles	Status	Check	Validation
5	7/1/2018	60000			A/C or Heater Repair	6	15000	Current		FALSE
6	7/1/2018	60000			Air Filter Change	3	12000	Due		TRUE
7	7/1/2018	60000			Battery Cables / Terminals			As Needed		FALSE
2011 Ford F150

Excel Workbook
	A	B	C	D	E
4	Last Date	Last O/D	Vehicle	Maintenance Performed	Performed By
5	7/1/2018	60000	2011 Ford F150	A/C or Heater Repair	Pepboys
6	7/1/2018	60000	2011 Ford F150	Air Filter Change	Pepboys
7	7/1/2018	60000	2011 Ford F150	Battery Cables / Terminals	Pepboys
Service Log

 

[Legacy 436357]

This may be cross-posting so I am sorry. The link to the other post is 'Post Checked Services to Service Log' in the Excel Forum.

Thank you for understanding.

https://www.excelforum.com/excel-pr...452-post-checked-services-to-service-log.html

 

[Legacy 436357]

bump