I am trying to create a macro that will cut a whole row if the cell in column K is equal to "Product". The Row that was cut must get pasted onto the next worksheet starting from row 2 onward. Also, I need all the cells from the first worksheet to move up once the row has been cut.
Please help.
Thanks,
Please help.
Thanks,