Home

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
abartend06
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?

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies