Hello all,
I never did a macro with a variable and don't know VBA that well.
I think this one could be an easy one. Can you help?
Column G has cells with values and cells that are empty.
I sort column G (A to Z), pushes the empty cells to the bottom of list. I then need to cut all these rows with the empty cells this column (G). Then paste them into a new worksheet with the name "Norp".
I never did a macro with a variable and don't know VBA that well.
I think this one could be an easy one. Can you help?
Column G has cells with values and cells that are empty.
I sort column G (A to Z), pushes the empty cells to the bottom of list. I then need to cut all these rows with the empty cells this column (G). Then paste them into a new worksheet with the name "Norp".