Filter-cut-paste to other sheet [Closed]

Report
-
Posts
2744
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 10, 2021
-
Hello,

Could you please help me on this one, i have a data sheet and i want to filter then cut the data if the criteria is met (Adhoc,Chaser,Exception). ----> [ FILTER---FILTER COLUMN G-----FILTER Adhoc----CUT DATA------PASTE IT TO CleanUp Sheet----BACK TO SHEET 1----FILTER----FILTER COLUMN G-----FILTER Chaser----CUT DATA------PASTE IT TO Chaser Sheet-----BACK TO SHEET 1----------FILTER--------FILTER COLUMN G-----FILTER Exception----CUT DATA------PASTE IT TO Exception Sheet, then after all 3 criteria has been paste(Adhoc,Chaser,Exception) Sheet1 should have no spacings due to cut.

Thanks in advance. I really need this bad :(


1 reply

Posts
2744
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
May 10, 2021
460
Hi Jonas,

Can't see what the problem is?

Where do you get stuck when applying your strategie?

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!