Hello everybody,
I need a help with macros.
I have a lot number of data in column A and I want to insert new filled rows after finding a special part of text. (special part of text in cells is DG)
Current state:
x
x
x
K1_DG1_OV
x
x
K1_DG2_OV
x
x
I want this situation:
x
x
x
K1_DG1_OV
K1_DG1_SP //new row
K1_DG1_P //new row
x
x
K1_DG2_OV
K1_DG2_SP //new row
K1_DG2_P //new row
x
x
Thanks in advance.
Bookmarks