Editing VBA to creat a new sheet without empty filtered rows

[mcarozza]

I have the following lines of code that create several new sheets and name and filter the data as specified. However, I also want it to create a new sheet that copies the data and pastes it with visible rows only: Here is what I currently have:

'****
'Create new copy of table, name "Growth" sheet, filter for g accounts and sort by QTF Abs Diff
'****
ActiveSheet.Copy after:=Sheets(1)
ActiveSheet.Name = "Growth"

Selection.AutoFilter Field:=9, Criteria1:="g"

Selection.Sort Key1:=Range(ABSQ), Order1:=xlDescending, Header:= _
xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

I am not an experience VBA user, but am looking forward to learning more!
Thank you.