I am looking to add 3-5 task rows to every sheet after an address change in the first column, with specific tasks for safety and the like.
The addresses changing will determine where to insert the extra lines.
Each address will have multiple tasks and some addresses will have more tasks than others.
Rather than adding 3-5 tasks manually at the end of each address change, I and wondering if they can be inserted with a macro.
First example is a single task for 123 Any Street and showing an example of what needs to be added.
Then I want to add a page break at the end of each address for printing pages to leave the sheet to check off they are complete at the address.
Thank you in advance,
The addresses changing will determine where to insert the extra lines.
Each address will have multiple tasks and some addresses will have more tasks than others.
Rather than adding 3-5 tasks manually at the end of each address change, I and wondering if they can be inserted with a macro.
First example is a single task for 123 Any Street and showing an example of what needs to be added.
Then I want to add a page break at the end of each address for printing pages to leave the sheet to check off they are complete at the address.
Location | Item | Material Status - Notes | Category | Assigned to | Progress |
123 Any Street | PAINT EXTERIOR DOORS GREY COLOR AND FRAMES WHITE | PAINT | PAINTERS | ||
Items to be inserted at the bottom of Every Sheet | Address needs be copied from the first column and inserted to the added rows. | The following items should always be the same. | |||
123 Any Street | Change Smoke detector batteries & Check Dated | 9V | Smokes | Bill | |
123 Any Street | Change Air Filter | HVAC | Bill | ||
123 Any Street | Change Thermostat Batteries | HVAC | Bill | ||
123 Any Street | Tighten Cabinet Door Hinges | Misc | Bill | ||
123 Any Street | Additional Misc Task | Misc |
Thank you in advance,