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.
