Split data into different worksheets in a new workbook.

Hi all,

I need help to write the macro for this.
I have attached a sample report that this macro needs to be run on.
So the macro that I need is basically look at the column I or "Store Code" heading and make a new worksheet for every different code.
Hope this makes sense, and thank you in advance for helping!

Kind regards,
Felix

Felix,

This will create a worksheet for each unique value in Column I. Im not sure what your wanting to due as your creating the sheets.

Please Login or Register  to view this content.

thanks that worked nicely by creating the sheets.
I also need to copy over the line of data that belongs to the store code. how do I do that?

So basically I want to create a sheet for every single store and the data that belongs to it in that sheet.

thanks again in advance!

Here's a sample of your workbook. Use CTRL+ m to run the code


Attachment 171361

Here's the code that will do what you want

Please Login or Register  to view this content.

hmm it seems to always crash at the end? sorry am I not doing it correctly....so confused....

Can you upload the workbook you are working with?

Here it is,

It's rather large and this is only about half of the original size

Attachment 171477

@fdotlix,

I ran the code on the workbook, how many sheets will the workbook create? It created 90 sheets. Try this workbook code. I added code to remove invalid characters from the sheet name.

yes there are 92 stores. when you run it did it stopped and gives an error?
i'm starting to think that my computer doesnt have enough RAM to run macro on such big range.

ah my bad found it ><

@fdotlix,

No I dont get any errors.

Thanks a lot Mike! the code works like a charm on Office 2010, it was because my machine was running 2003. ><
Such a great help, really appreciated! =D

@fdotlix,

Dont forget to mark your post as Solved!

@ fdotlix

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.