Filtering data and moving each filtered columns to a new sheet. Large data set

%3CLINGO-SUB%20id%3D%22lingo-sub-1998138%22%20slang%3D%22en-US%22%3EFiltering%20data%20and%20moving%20each%20filtered%20columns%20to%20a%20new%20sheet.%20Large%20data%20set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1998138%22%20slang%3D%22en-US%22%3EI%20am%20trying%20to%20filter%20column%20A.%20There%20are%20100%2B%20unique%20values%20in%20column%20a%20and%20I%20want%20to%20move%20each%20onto%20its%20own%20sheet%20or%20it%E2%80%99s%20own%20excel%20doc.%20I%20want%20all%20the%20columns%20included%20when%20moved.%20Can%20someone%20help%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1998138%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1999689%22%20slang%3D%22en-US%22%3ERe%3A%20Filtering%20data%20and%20moving%20each%20filtered%20columns%20to%20a%20new%20sheet.%20Large%20data%20set%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1999689%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F905302%22%20target%3D%22_blank%22%3E%40msirois%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECould%20we%20first%20ask%20you%20what%20is%20going%20to%20happen%20next%3F%20Asked%20another%20way%2C%20what%20is%20the%20bigger%20picture%20here%3F%20What's%20the%20overall%20project%20of%20which%20this%20is%20just%20a%20small%20part%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20reason%20for%20asking%3A%20it%20may%20well%20be%20that%20you're%20trying%20to%20something%20that%20is%20unnecessary%20in%20the%20first%20place.%20It%20may%20be%20that%20Excel%20(which%20has%20remarkable%20abilities%20to%20work%20from%20a%20single%20large%20database)%20can%20do%20that%20extracting%20at%20a%20different%20stage%20of%20the%20bigger%20project%2C%20perhaps%20producing%20whatever%20it%20is%20you%20want%20to%20do%20ultimately%20---%20presumably%20adding%20more%20info%20to%20each%20page%2C%20or%20whatever--%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20said%2C%20I'm%20sure%20a%20macro%20or%20VBA%20routine%20could%20be%20written%20to%20accomplish%20the%20task%20you%20requested.%20I'm%20asking%20my%20%22design%20question%22%20just%20to%20see%20if%20there's%20a%20better%20way%20to%20do%20the%20bigger%20job%20in%20the%20first%20place.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I am trying to filter column A. There are 100+ unique values in column a and I want to move each onto its own sheet or it’s own excel doc. I want all the columns included when moved. Can someone help?
1 Reply

@msirois 

 

Could we first ask you what is going to happen next? Asked another way, what is the bigger picture here? What's the overall project of which this is just a small part?

 

The reason for asking: it may well be that you're trying to something that is unnecessary in the first place. It may be that Excel (which has remarkable abilities to work from a single large database) can do that extracting at a different stage of the bigger project, perhaps producing whatever it is you want to do ultimately --- presumably adding more info to each page, or whatever-- 

 

That said, I'm sure a macro or VBA routine could be written to accomplish the task you requested. I'm asking my "design question" just to see if there's a better way to do the bigger job in the first place.