How can I use same filter for different worksheets and filter independently ?
I have used same filter for three different worksheets. If I want to filter only one sheet, other sheets also gets filtered. How can I avoid this ?
You may right click on the filter and choose which worksheet to apply for each worksheet. Please find below screenshot and let me know if I didn't understand your question correctly.
Thank you. I also just figured it out.
Retrieving data ...