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