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.
