cmschmitz24
Board Regular
- Joined
- Jan 27, 2017
- Messages
- 150
Hello,
I need help writing a code that will add a blank row underneath each unique value in column B.
Then in the blank row, copy/paste the data from the row above it.
Example
A2 00037924 B2 0 C2 CP
A3 00039761 B3 1 C3 AS
will look like
A2 00037924 B2 0 C2 CP
A3 00037924 B3 0 C3 CP
A4 00039761 B4 1 C4 AS
A5 00039761 B5 1 C5 AS
Thanks!
I need help writing a code that will add a blank row underneath each unique value in column B.
Then in the blank row, copy/paste the data from the row above it.
Example
A2 00037924 B2 0 C2 CP
A3 00039761 B3 1 C3 AS
will look like
A2 00037924 B2 0 C2 CP
A3 00037924 B3 0 C3 CP
A4 00039761 B4 1 C4 AS
A5 00039761 B5 1 C5 AS
Thanks!