ExcelStarter123
New Member
- Joined
- Aug 9, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi,
I have an excel which contains a first row of headers & 10,000 rows in total (sheet 1). I have created a table in sheet one to pick up all filled value cells (columns A to AG). Using the table, I was able to insert multiple slicers which reference various columns in sheet 1. The slicers have been pasted in a separate tab.
I have a VBA code which lets me paste the filtered rows (active cells) into a separate tab (sheet 2). However, I would like to limit the rows copied (to sheet 2) to the first 1000 filtered rows.
I have an excel which contains a first row of headers & 10,000 rows in total (sheet 1). I have created a table in sheet one to pick up all filled value cells (columns A to AG). Using the table, I was able to insert multiple slicers which reference various columns in sheet 1. The slicers have been pasted in a separate tab.
I have a VBA code which lets me paste the filtered rows (active cells) into a separate tab (sheet 2). However, I would like to limit the rows copied (to sheet 2) to the first 1000 filtered rows.