Filter-cut-paste to other sheet

[Closed]
Report
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 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
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
486
Hi Jonas,

Can't see what the problem is?

Where do you get stuck when applying your strategie?

Best regards,
Trowa