Dear Team,
I'm seeking you help in the following:
as the title says, i'd like to move entire row based on cell value. Basically, in my sheet fifth column represent STATUS . It can be either " P1, P2, P3 or Confirmed". i want the row to be moved to associated sheet ( sheet 1 = P1...sheet2 = p2.....sheet3=P3..sheet4=Confirmed).
So if status P1 to be moved to sheet1 which is P1 sheet and deleted it from the master sheet ( The main sheet name "Master" ).
I do hope that this is clear if not i can attach the workbook.
Thank you in advance
Bookmarks