HI AStongizmo

Ill write a demo for you latter today which includes the suggestions made
by Dana

Have to work now

Best N10 :)
"Astongizmo" wrote in message
...
Thanks for taking the time to respond. I've never used code before either,
so
how do I do the first bit "With code select the filtered range"?

"N10" wrote:

Hi

Try this


With code select the filtered range

then use

Selection.SpecialCell(xlCellTypeVisible).Select
Selection.Copy

This copies only the cells visble as a result of the filter criteria

N10 ;)



"Astongizmo" wrote in message
...
Hi - I'm new to macros and the answer to my question is probably
already
posted.

I have a spreadsheet containing an autofilter. This always returns the
same
number of columns but the number of rows can vary. I want to copy the
displayed rows only to a second sheet building up a list on the second
sheet,
so each time I select a new filter the result will be copied to the
second
sheet below any data already there. As a second stage I want to sort
the
second sheet and extract all rows where a certain column matches a
fixed
criteria into a further sheet. This second stage will require to be
done
twice as the criteria changes.

Any help will be gratefully received.