Copy select info on Main sheet, in same format maintaining conditional formatting, to new sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-914673%22%20slang%3D%22en-US%22%3ECopy%20select%20info%20on%20Main%20sheet%2C%20in%20same%20format%20maintaining%20conditional%20formatting%2C%20to%20new%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-914673%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20Main%20data%20sheet%2C%20stuffed%20with%20conditional%20formatting%20and%20special%20formulas%2C%20which%20I%20use%20extensively.%20But%20I%20have%20five%20sales%2Fops%20teams%20that%20don't%20want%20to%20see%20the%20entire%20sheet%3B%20instead%20they%20want%20to%20see%20just%20their%20data.%20I%20haven't%20able%20to%20figure%20out%20a%20pivot%20table%20that%20can%20parse%20out%20the%20select%20info%20while%20salvaging%20the%20layout%20and%20formatting.%20More%20specifically%2C%20I%20have%20a%20main%20data%20sheet%20with%20deadlines%20for%20various%20agencies%20for%20four%20venues.%20After%20the%20data%20sheet%2C%20I%20want%20a%20sheet%20for%20each%20venue%20of%20just%20their%20deadlines%2C%20but%20I%20want%20all%20the%20columns%20and%20formatting%20preserved%2C%20so%20that%20they%20look%20just%20like%20the%20main%20sheet%2C%20but%20with%20only%20one%20venue's%20worth%20of%20info.%20Is%20this%20possible%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-914673%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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?

0 Replies