Hello,
I would like to copy and insert a row below the original row, according to 2 specific values in column B.
But, change column B cell's value on the inserted row, for each specific value from original row.
Is there a way to do this with a VB or macro? Thank you in advance
Original column B values FIRE_STEP_UP and FMLA_APPROVED_LEAVE
New Column B values WRK and SICK
See attached.
I would like to copy and insert a row below the original row, according to 2 specific values in column B.
But, change column B cell's value on the inserted row, for each specific value from original row.
Is there a way to do this with a VB or macro? Thank you in advance
Original column B values FIRE_STEP_UP and FMLA_APPROVED_LEAVE
New Column B values WRK and SICK
See attached.