Copying top 5 rows after applying filters

[akeem1234]

The issue I'm having is that I want to copy the first 5 rows after a filter has be applied which has changed the order of the row number on the side, i want the macros to always take the top 5 of what i have filtered but it will always look for the number row instead of the row numbers that are in the top 5 of my filter. How could i get around this, please help.

 

[akeem1234]

Hi,

Thank you for this code, this works perfectly, amazing job!!!