I have a Main data sheet, stuffed with conditional formatting and special formulas, which I use extensively. But I have five sales/ops teams that don't want to see the entire sheet; instead they want to see just their data. I haven't able to figure out a pivot table that can parse out the select info while salvaging the layout and formatting. More specifically, I have a main data sheet with deadlines for various agencies for four venues. After the data sheet, I want a sheet for each venue of just their deadlines, but I want all the columns and formatting preserved, so that they look just like the main sheet, but with only one venue's worth of info. Is this possible?
