Afternoon all,
With much searching occurring around the interwebs I cannot find an answer to this, so here's what I would like to achieve!
Macro InsertRow()
When new row is inserted below the last used row, I need the following to occur within the worksheet "Register".
-Kyle.
With much searching occurring around the interwebs I cannot find an answer to this, so here's what I would like to achieve!
Macro InsertRow()
When new row is inserted below the last used row, I need the following to occur within the worksheet "Register".
- The cell above the new row in Column A is merged,
- The formatting and formula in Column P is copied into the new row, and
- All other values apart from the previous two mentioned are cleared
-Kyle.