I have a file with approx. 82,000 (varies by week) rows and 40 named columns. There are 65 unique districts identified in the data. My ideal scenario would be to automate the function of creating new files segregated by the unique districts. In other words 65 files (or tabs if unique individual files are not attainable), each containing the rows for each district.
Thank You.
Re: Create new tabs (or files) from data
Both are possible just using Excel basics like for example an easy advanced filter
so at least just well explain what you expect for,
and that's better with an attachment containing a source workbook and an expected result workbook …
Hi Allan,
Before you split your data up into different tabs, learn about AutoFilter to see if it does what you need first. Select any cell in your data and click on the Data Tab and then on the Filter Icon. This creates dropdowns across the top row. (You should really have column titles across the top row). Click the dropdown for districts and filter ALL the data to only show that district.
If AutoFilter is too hard to handle then Advanced Filters might be better for you. Learn about those too, as they could easily lead you to your separate tabs solution. Simply put the criteria on a separate tab and refresh all to split your data between new tabs.
Time to learn Advanced Filter?
See if the below site helps.
https://www.extendoffice.com/documen...her-sheet.html
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
District is column "D" ?
There is no header ??
- Battle without fear gives no glory - Just try
Re: Create new tabs (or files) from data
As an advanced filter needs only a single codeline to filter and copy data to the destination …
But whatever filtering or advanced filtering like any Excel beginner can operate manually,
it can't be possible without a headers top row (respecting Excel spirit).
Yes, column D is the district. Sorry for the omission of the headers in the example.
Well reading is the way for a solution …
As I wrote :
Originally Posted by Marc L
Both smart enough, with headers …
See next code
Please Login or Register to view this content.
Thank You very much.
You're welcome.
Glad to help
PCI, SpecialCells for visible cells is useless as the Range.Copy method takes care only of visible cells …
@Marc
Yes, thank you, an old habit, it's time to changeSpecialCells for visible cells is useless as the Range.Copy method takes care only of visible cells …
An update
See at the end
Please Login or Register to view this content.Please Login or Register to view this content.
Thank You. The code has worked great.
That being said, is it possible to add additional code that would "Autofit Column Width" as the new files are created?
or
Please Login or Register to view this content.
See here after
Please Login or Register to view this content.
Still shorter and faster
Please Login or Register to view this content.
Thank you very much.
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks