L
Legacy 436357
Guest
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.
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 |