I can insert blank rows between the data when value changes. I am asking how to add the same 7 rows of common data (as in a checklist) to the top or bottom of every sheet and also add the data from the A column after the change to the 7 rows. I can add them to the top of the list with the rows to repeat at the top $1:$7 however this method does not include the data from Column A. I would prefer to add the 7 rows to the top or bottom and add the data from the current A Column before the data changes. Thank you for your help.
BEFORE
The data in Column A (location) could be listed 1 time or 50 times until the next address and the blank on the 7 lines at $1:$7 are always the same to be added to the list.
A could have:
Sheet would look like this when VBA is finished
Thank you for your help
BEFORE
LOCATION | TASK OR ITEM REPAIRS REQUIRED | CATEGORY | NOTES - MATERIAL STATUS | ASSIGNED TO | STATUS OR TASK IS IT COMPLETE? |
REPLACE THE SMOKE DETECTOR BATTERIES IF THEY ARE REPLACEABLE | BATTERY | N/A TO 10 YEAR SYSTEMS | RICK | ||
REPLACE THE DOOR LOCK BATTERIES | BATTERY | RICK | |||
TIGHTEN ALL CABINET DOOR HINGES | GENERAL | TOM | |||
CHANGE THERMOSTAT BATTERIES | BATTERY | N/A TO 10 YEAR SYSTEMS | BILL | ||
CHANGE AIR FILTERS AS REQUIRED | FILTERS | JOE | |||
PLEASE BE SURE A/C IS OFF WHEN LEAVING AT THE END OF THE DAY | EVERYONE | CHECK DAILY IF NOT OCCUPIED | EVERYONE |
121 MAIN STREET | BED 5 - PAINT ALL | PAINT | JOE | COMPLETE | |
121 MAIN STREET | LR- PAINT 3 WALLS | PAINT | JOE | COMPLETE | |
121 MAIN STREET | BED 4 REPAIR LOCK | LOCK | PLUNGER WAS BAD, REPLACED 06/04/24 | JOHN | COMPLETE |
The data in Column A (location) could be listed 1 time or 50 times until the next address and the blank on the 7 lines at $1:$7 are always the same to be added to the list.
A could have:
Sheet would look like this when VBA is finished
LOCATION | TASK OR ITEM REPAIRS REQUIRED | CATEGORY | NOTES - MATERIAL STATUS | ASSIGNED TO | STATUS OR TASK ITEM COMPLETE |
121 MAIN STREET | REPLACE THE SMOKE DETECTOR BATTERIES IF THEY ARE REPLACEABLE | BATTERY | N/A TO 10 YEAR SYSTEMS | RICK | |
121 MAIN STREET | REPLACE THE DOOR LOCK BATTERIES | BATTERY | RICK | ||
121 MAIN STREET | TIGHTEN ALL CABINET DOOR HINGES | GENERAL | TOM | ||
121 MAIN STREET | CHANGE THERMOSTAT BATTERIES | BATTERY | N/A TO 10 YEAR SYSTEMS | BILL | |
121 MAIN STREET | CHANGE AIR FILTERS AS REQUIRED | FILTERS | JOE | ||
121 MAIN STREET | PLEASE BE SURE A/C IS OFF WHEN LEAVING AT THE END OF THE DAY | EVERYONE | CHECK DAILY IF NOT OCCUPIED | EVERYONE |
121 MAIN STREET | BED 5 - PAINT ALL | PAINT | JOE | HOLD OFF LAST | |
121 MAIN STREET | LR- PAINT 3 WALLS | PAINT | JOE | HOLD OFF LAST | |
121 MAIN STREET | BED 4 REPAIR LOCK | LOCK | PLUNGER WAS BAD, REPLACED 06/04/23 | JOHN | COMPLETE |
Thank you for your help