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
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.