Find and transfer data

%3CLINGO-SUB%20id%3D%22lingo-sub-1661744%22%20slang%3D%22en-US%22%3EFind%20and%20transfer%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661744%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20large%20database%20of%20professionals%20and%20want%20to%20select%20a%20certain%20type%20under%20the%20position%20column.%20Such%20as%2C%20'Financial%20Advisor'.%20And%20then%2C%20transfer%20all%20of%20the%20Financial%20Advisors%20to%20another%20workbook.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1661744%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1661781%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20and%20transfer%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1661781%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F791893%22%20target%3D%22_blank%22%3E%40Peanutnut%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20that's%20one-time%20operation%20you%20may%20filter%20the%20data%20and%20copy%2Fpaste%20into%20another%20workbook.%20Power%20Query%20could%20be%20an%20option%20if%20data%20is%20changing%20from%20time%20to%20time.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a large database of professionals and want to select a certain type under the position column. Such as, 'Financial Advisor'. And then, transfer all of the Financial Advisors to another workbook.

2 Replies

@Peanutnut 

If that's one-time operation you may filter the data and copy/paste into another workbook. Power Query could be an option if data is changing from time to time.

@Sergei Baklan 

Thanks Sergie, but I'm not even sure how to filter it. New to this