Macro to filter sheet and copy to another
 

Well, it doesn't use Autofilter, but if the functions in the
downloadable file at http://home.pacbell.net/beban are available to your
workbook, and assuming your unfiltered data consists of 50 rows in a
range named "datarange", you can array enter into the following ranges
on the sheet to which you want to copy the data:

A1:C50
=SubArray(ArrayRowFilter1(datarange,20,"Amended"), 1,3,1,ArrayCountif(Sheet1!T1:T9,"Amended"))

D1:J50
=SubArray(ArrayRowFilter1(datarange,20,"Amended"), 7,14,1,ArrayCountif(Sheet1!T1:T9,"Amended"))

K1:M50
=SubArray(ArrayRowFilter1(datarange,20,"Amended"), 17,19,1,ArrayCountif(Sheet1!T1:T9,"Amended"))

#N/A! will be returned to the extra irrelevant rows.

Alan Beban

Gareth wrote:
I want to used AutoFilter to filter column T on Sheet1 for the word
'Amended'.

If there are any found, I would like to copy only certain columns to Sheet2.

The columns are A:C, G:M, Q:S

Thanks in advance.

Gareth