Hi,
I wanted to know if excel support a feature where if I filter a selection on sheet, the selection carries over to the other sheets in the same workbook.
I am working with excel 2010.
For example if I filter to a specific Item#, the other sheets will filter to that Item# as well.
If its possible, can you please guide me as to how to go about it.
Thank you,
I wanted to know if excel support a feature where if I filter a selection on sheet, the selection carries over to the other sheets in the same workbook.
I am working with excel 2010.
For example if I filter to a specific Item#, the other sheets will filter to that Item# as well.
If its possible, can you please guide me as to how to go about it.
Thank you,