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.