Parsing out file into multiple new files

**CrystalNewb** · 11-16-2009, 04:14 PM

Hello,

I need to separate a very large excel file into multiple files based on what's in a single column.

I am an intern at my district school board and I'd love to know if there is a way to do this.
In the attached file the first tab is an example of some of the information I have in my file. My file is thousands of rows larger. The next few tabs are examples of new files (not just new tabs) That I would like separated and saved somewhere on my hard drive.

Notice the files are split up based on the student.

Is there a way to parse out this information into new files? The file is huge and I need it to do this automatically. If it isn't possible to save new files, is it possible to parse out the students into new tabs? But I have too many students I think. How many Sheet Tabs can you have in 1 file?

Please Help!
Let me know if you need anymore info.

**JBeaucaire** · 11-16-2009, 04:25 PM

You can have as many tabs in the workbook as you have memory in your computer.

I have macros that filter data into separate workbooks and into separate sheets in the same workbook. Either are equally simple.

But I would have to vote that separate tabs in the same workbook to be more manageable. I can't think that finding and opening separate workbooks out of 100s of students is easier than navigating in a single workbook.

What do you think?

If you go with individual sheets, then we wouldn't be adding the word "file" to the names in column C, would we?

**JBeaucaire** · 11-16-2009, 04:31 PM

Here's a macro I did for someone a few days ago, I literally changed the column reference and the "original" sheetname and it works as is. Give it a try.

Please Login or Register  to view this content.

**CrystalNewb** · 11-16-2009, 04:56 PM

Thank you so much! that worked perfect!!!

Now I need a way to save each worksheet separately into new files.

This is the last step in my problem! It will be perfect if I can get it to do this.

**JBeaucaire** · 11-16-2009, 06:08 PM

A separate routine:

Please Login or Register  to view this content.

**CrystalNewb** · 11-17-2009, 09:01 AM

I thought that was the last step in my problem, but since I'm able to that, I'm starting to see what else might be possible.

I'm pretty sure these two things are impossible for excel to do, but if I could do even one of them I would be extremely happy!

The first thing I want to do is, when I save the worksheets as separate files, I want to create a pie chart that shows that students grades. I realize to graph the grades I will first need to count the number of A's, B's, C's, D's, and F's. I would reattach the file with this count, but I'm not at a place where I can attach .xls files right now.

Basically I want, from my original data, first to parse out the individual students data into multiple worksheets, which I can do. Next I want to save each of those worksheets to separate files to my hard drive. I can do this as well thanks to you help. With those files I want to create a graph (pie chart) That shows only that students data.

This seems impossible to me so I'm not expecting to be able to do this.

The second thing I want to do, which is basically unrelated to the first, is:
I have a .xls file with a bunch of worksheets, each with its own graph. Is it possible to save each of the worksheets as different files (like I've been able to do) but instead of keeping the files .xls format, I want to change the format to .pdf.

Again this seems impossible to me, I'm not sure if excel has that capability

**JBeaucaire** · 11-17-2009, 11:06 AM

If that takes care of the posted need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)

=======
Best to start completely new questions in new threads with appropriate thread titles.

**CrystalNewb** · 11-17-2009, 01:51 PM

The first part is solved, but I could still use some help with my questions in the post above

**Marzuk** · 11-17-2009, 02:02 PM

Everything you are doing here seems like it would be FAR better to shove into an access database then query what you need. If you come up with something you need down the road but have the data in a database you can probably pull it out without much trouble.

Have you considered using Access?

**JBeaucaire** · 11-17-2009, 02:34 PM

Hi Crystal.

Try to think of this thread as the "Parsing out file into multiple new files" thread, and not the "all the questions Crystal has about her one sheet project" thread.

As per forum rules (which make the forum "searchable" effectively for people doing their own research), completely new questions should go into new threads with new defining topic titles. If prior threads are relevant you can include a link to them.

But this thread should be marked off as solved, OK?

========
This is for your benefit, too. Brand new threads get the most attention from the most people. This thread already has 10 posts in it, so the only people reading this thread now are usually the people already in it. So you garner new "blood" by starting a new thread.