I am using Microsoft Excel 2003. When I use auto filter option, it filters the data.
But when I try to copy that filtered data to another sheet it does not work.
The whole list is copied to another sheet.Â
Thanks for the question,
It's unfortunate that it's impossible to copy hidden rows of filtered data when copying filtered data to a new spreadsheet. However, it's possible to copy the visible filtered data and you need to follow just a few steps,
first, select the filtered data and press CTRL + C to copy the data.
2nd, select the spreadsheet where you going to paste the data.
3rd, Press CTRL + V to paste the data. Alternatively, select the data you want to copy, click on insert and select table, then you can transfer the data to another work sheet.
Code:
Sometimes we face such a problem but don't worry dear friend follow the steps and get solution.
SOLUTION-1
Step-1:
Make a copy of that sheet which you want to filter.
Step-2:
Now, filter the copied sheet as you desire.
Step-3:
Select the filter data and cut it and past on another sheet.
SOLUTION-2
Step-1:
Make a copy of that sheet which you want to filter.
Step-2:
Now, filter UNWANTED data from the copied sheet.
Step-3:
Select the filter data, delete all rows and remove filter.
Conclusion
Solution-1 and Solution-2 are perfect solutions.
Hope it will solve your problem.
Thanks and regards.
IRSHAD AHMED KHAN
