New files based on column data

We're going to need a little more information than this. I'll assume the file names you want to create are contained in column C. What would you like in these files? What format would you like them to be in (XLSX, XLSB)? Where do you want them (same directory or some other directory)?

And even though it would be simple enough to set up a workbook to do this, it would be better if you supply one.

sorry -- attached is a basic file type. I was able to find one that broke them apart as tabs then created files on Mr.Excel after reading the reference material but having a way to group them by P/L (examples would be 100-199 would go to a file called 1st shift, 200-299 2nd shift, 300-399 3rd, etc.) would be amazingly valuable.

Please Login or Register  to view this content.

First of all, read up on how to insert code tags. I suggest you go back and put them in or a moderator may clamp down on you. They are normally nice enough to add them for you the first time, but you should learn to do it for yourself. Since I am not bothering with the code (I intend a complete re-write), I'm OK with it for now.

Add Code Tags
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html

Now for some additional questions. I'm looking at column C - I assume, even though there is scant data here that there should be multiple rows and that they could be 112, 113, 114, 211, 212, 311, 314, etc.

What you want to do is group all the 100s into First Shift, All the 200s into Second shift and all the 300s into third shift. So if my sample entries were the only entries, then the rows containing 112, 113 and 114 will go into the first shift file, 211, 212 go into second shift file and 311, 314 go into third shift. Please confirm

Another question: how is this data entered? Are you doing it manually in the workbook, or do you get this workbook from someone else? It makes a difference where I put the code. If you are doing the maintenance in this workbook, I'll put the code in this workbook. If you get a new workbook every day, then the code belongs in another workbook that opens the daily workbook and works on that.

Here is a spreadsheet that should do what you want it to do.

Put the source file in the same directory with this file. Enter the name of the source file in Cell B1.

In the table in columns G:I, set up the Groups you want. Whatever is in column G will be the file name of the result. So this could be Shift 1, Shift 2, etc. The only caveat here is to make sure you do not include a character that is illegal for a file name. In columns H and I, include the break points for the group. You can have as many rows as you want.

The results will come out in the same directory as this spreadsheet.

Here is the test file I used.