Clearing rows after autofiltering

L

Liketoknow

Hi

I have recorded a macro to copy the data from 1 sheet to another and then
autofilter the data on sheet 1 of all rows with any value in column 8 and
sheet 2 to autofilter the data of blank rows in column 8

works good
I however would like to be able to clear the contents (rows) i don't need
from sheet 1 to keep the size of the sheet down

any help would be appreciated

heres my macro

Sheets("Filled Requests").Select
Sheets("Panel Orders").Range("B6:I90").AdvancedFilter Action:=xlFilterCopy _
, CriteriaRange:=Sheets("Panel Orders").Range("B6:I90"), CopyToRange:= _
Range("B6:I90"), Unique:=False
Sheets("Panel Orders").Select
Range("B6:I90").Select
Selection.AutoFilter
Selection.AutoFilter Field:=8, Criteria1:="<>"
Selection.AutoFilter Field:=8, Criteria1:="="
Sheets("Filled Requests").Select
Range("B6:I25000").Select
Selection.AutoFilter
Selection.AutoFilter Field:=8, Criteria1:="<>"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help me4 2
How to Activate Filter in Protected Sheet 2
How do I choose the rows that are filtered ? 1
Selection.AutoFilter Issue 1
AutoFilter Criteria using named range 4
Automated autofilter error 1
Excel 2003 autofiltering options from a userform 0
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3

Top