SOLVED

Help Please

%3CLINGO-SUB%20id%3D%22lingo-sub-2653889%22%20slang%3D%22en-US%22%3EHelp%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2653889%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%205%20worksheets%20in%20an%20excel%20document.%20I%20need%20to%20a%20filter%20column%20and%20select%2030%20items%20in%20a%20list%20of%20100.%20I%20need%20to%20do%20this%20on%20all%20worksheets.%20Is%20there%20anyway%20to%20copy%20and%20paste%20the%20filter%20data%20for%201%20column%20to%20another%20worksheet%3F%20It%20would%20be%20so%20helpful.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%26nbsp%3B%3C%2FP%3E%3CP%3EKim.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2653889%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2654349%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Please%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2654349%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1129781%22%20target%3D%22_blank%22%3E%40Kimberly570%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fyoutu.be%2FVqQACB_69SQ%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutu.be%2FVqQACB_69SQ%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have 5 worksheets in an excel document. I need to a filter column and select 30 items in a list of 100. I need to do this on all worksheets. Is there anyway to copy and paste the filter data for 1 column to another worksheet? It would be so helpful.

 

Thank you! 

Kim.

1 Reply
best response confirmed by Kimberly570 (Occasional Visitor)
Solution
Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentialsHow does Advanced Filter work in Excel? In this quick tutorial I show ...