Hi Steph!

You should be able to select your data that you've filtered, copy or cut it,
then paste onto the other sheet. The filtered/selected data should now be
in your "sheet 2".

Remember if you cut it (not copy) out of sheet 1, you might get spacing
you'll have to clean up when you turn the filter off. You could sort that
data in some fashion prior, that may reduce the spacing.

does this help?

"Steph" wrote:

How can I copy a set of data from sheet 1 to sheet 2 after I have filterd the
data in sheet 1 to only include the data I want.

The number of rows is always variable.

Please Help?