May 04 2021 05:37 PM
Hello,
I am on a Windows 10 computer and Microsoft Excel 2008. I have a file with 1,000 categories in column A. I would like to create a new Excel file for each of the categories in Column A and name the files after the category. Is there a way to automate that so I don't have to do it manually? Thanks
May 04 2021 07:47 PM
There may be a way to do what you're asking via a macro or VBA routine. I don't use those much at all, so I'll let somebody else address that part of what you're asking.
If you don't mind a different question, though, may I ask before you succeed in doing what you're asking, "WHY?" Why are you wanting to create 1,000 different Excel files, one for each sub-category (or category) of whatever it is that clearly must have something in common in order to be in a single column to begin with?
1,000 separate sheets are going to be quite unwieldy. A single database can have thousands of rows and tens or hundreds of columns, and be very navigable, very useful.
You may have an entirely valid reason, a good purpose in mind...maybe the 1,000 spreadsheets are going to be farmed out to 1,000 different people to manage. But I'd sure want to know you're not just creating a major headache for yourself. And it's a question I'd ask if we were sitting down face-to-face; so I hope you don't mind my asking in this forum,
May 05 2021 09:23 AM
Hi there thanks for asking. So essentially it has to do with billing purposes. The categories need to go to different organizations.
I should have mentioned there is some data within each category that will be need to sent over as well.
May 05 2021 10:03 AM
May 10 2021 04:20 PM