I have a report that pulls in information from various tables. This report can be filtered by different sections. I'm trying to create new sheets copied from original, to break down each section on it's own sheet.
My issue is, I can copy and paste but once I filter the original sheet, the other sheets filter data to whatever is on original sheet.
How can I keep the copied sheets to filter independently and not revert to original sheet changes?
For example.
I have a job that has different sections (i.e. plumbing, electrical, AC) I want to create a new sheet tab for each of these sections so they show their own costs but I want each tab to stay on that section, not change when i work on the original sheet.
Bookmarks