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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Copying top 5 rows after applying filters
- Thread starter akeem1234
- Start date
Excel Facts
Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Similar threads
- Replies
- 18
- Views
- 528
- Replies
- 2
- Views
- 109
- Question
- Replies
- 0
- Views
- 179
- Replies
- 17
- Views
- 270
- Replies
- 3
- Views
- 103
