Splitting data in excel tabs/sheets

%3CLINGO-SUB%20id%3D%22lingo-sub-2552698%22%20slang%3D%22en-US%22%3ESplitting%20data%20in%20excel%20tabs%2Fsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2552698%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20thank%20you%20for%20going%20through%20my%20request%2Fquestion.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20set-up%20a%20template%20with%20variable%20data%20(List%20of%20companies).%20With%20this%20template%20I%20would%20like%20each%20company%20present%20in%20my%20data%20list%20to%20have%20one%20separated%20excel%20sheet%2Ftab.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20any%20tips%20and%20tricks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2552698%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2552832%22%20slang%3D%22en-US%22%3ERe%3A%20Splitting%20data%20in%20excel%20tabs%2Fsheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2552832%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F187543%22%20target%3D%22_blank%22%3E%40BVE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20for%20example%20%3CA%20href%3D%22https%3A%2F%2Feileenslounge.com%2Fviewtopic.php%3Fp%3D274467%23p274467%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ethe%20macro%20in%20this%20post%3C%2FA%3E%20for%20a%20starting%20point.%20Or%20%3CA%20href%3D%22https%3A%2F%2Fsocial.msdn.microsoft.com%2FForums%2FSqlServer%2Fen-US%2F19ec34cd-cc37-499d-aa82-bd6971b19d4f%2Fhow-to-split-data-into-multiple-worksheets-based-on-column-in-excel-2013%3Fforum%3Dexceldev%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ethis%20very%20long%20topic%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Visitor

Hi All,

 

And thank you for going through my request/question.

 

I am trying to set-up a template with variable data (List of companies). With this template I would like each company present in my data list to have one separated excel sheet/tab.

 

Thank you for any tips and tricks

1 Reply

@BVE 

See for example the macro in this post for a starting point. Or this very long topic