Questions

Copy filter to multiple sheets in excel.

Tags:
+
0 Votes
Locked

Copy filter to multiple sheets in excel.

mick28mx
Hello group,
I have the following question:

I have a workbook in excel 2010 with 3 worksheets. On each one I have data in five columns that I need to filter with some criteria.

At this time, on each sheet I put the same filter on each worksheet. This is, I did the same three times.

Is there any way to copy the same filter from worksheet 1 to the other two, without typing on each one?

I know that I can copy all the data in one sheet and do the filtering thing once. But, due to the number of records this can??t be done.

Thank you in advance.
  • +
    0 Votes
    saffagirl

    Hi Mick28mx,

    If I am reading your original question correctly, you should be able to just copy the cells, columns or rows containing your filter and paste it into the new worksheet. Alternatively you could just make a copy of the worksheet and remove the rows you no longer need thereby leaving the filter in place.

    Saffa Girl

  • +
    0 Votes
    saffagirl

    Hi Mick28mx,

    If I am reading your original question correctly, you should be able to just copy the cells, columns or rows containing your filter and paste it into the new worksheet. Alternatively you could just make a copy of the worksheet and remove the rows you no longer need thereby leaving the filter in place.

    Saffa Girl