Hi

I have three columns (Item, Total, Name), the below code goes to item column
then put autofilter, after that selects Business from the item column , item
column contains Business, Sales, Scrapes etc..., till here its working fine
after this i need the macro to select and copy the first five rows only.

Actually when you put autofilter to select Business, few columns like sales
, scrapes etc.. column will be hidden , which i do't need when iam selected
Business, and the range also differ always..

Sub test()
Range("A1").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:="Business"
Range("A1:C1").Select

' copy only five rows

End Sub