I'm using an Autofilter to filter class results & marks, I need to copy the
results into separate (already existing) spreadsheets, the problem I have is
that the range initially selected on the first path is an absolute reference
and changing the references to relative doesn't help either, as the results
are filtered with their original column and row postitions.
How do select the rows returned in the filter? I have about 100 spreadsheets
to fill in this way.

Many thanks

Sorry people, posted in wrong section...should have been in Excel!

"Wendy" wrote:

> I'm using an Autofilter to filter class results & marks, I need to copy the
> results into separate (already existing) spreadsheets, the problem I have is
> that the range initially selected on the first path is an absolute reference
> and changing the references to relative doesn't help either, as the results
> are filtered with their original column and row postitions.
> How do select the rows returned in the filter? I have about 100 spreadsheets
> to fill in this way.
>
> Many thanks
>
>