Filter-cut-paste to other sheet

Closed
JONAS - Feb 5, 2012 at 09:01 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 14, 2012 at 09:08 AM
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 :(


Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Feb 14, 2012 at 09:08 AM
Hi Jonas,

Can't see what the problem is?

Where do you get stuck when applying your strategie?

Best regards,
Trowa
0