macro to autofilter and copy first 15 lines visible lines in columns D:E

Hello everybody,

I am struggling to write a code that should do the following to my datatable (10 columns, cca 5000 lines, headers in first row):

1. filter data based on some characteristic from column A (using autofilter)
2. then filter data deeper based on some characteristic from column B
3. sort values in column C from largest to smallest.
4. copy range of first 15 values from columns D:E to another sheet.

I have a problem with step 4.
How can I tell excel to select only first 15 visible cells (they will be in various lines) and select only the selected range (D:E)

Many thanks to any idea!

Perfect! Thank you both for your help guys!

Have a nice day,
Juraj