need vba to split sheet into multiple sheets

[thuff]

I need help quickly & don't have vba experience! I have attached an example of how the whole workbook needs to look. The first tab (Full Report) is the original file I have to work with. I need to take that original sheet & split it into the various individual sheets. I've looked online & tried various code listed out there but none have worked for me & I don't know enough to customize for my needs. I'm also wondering if my original sheet needs to be changed a little since the information I need to pull into separate sheets is included in fields in column A. Any help is much appreciated!

[JasperD]

Hi there thuff,

now the code below is pretty crude, cause I want to go to sleep
It assumes the following about the workbook you're going to run it on: There is only 1 sheet with data - and that one is called "full report"
Make sure that's true

It will mess up your "full report" page, but I really didn't have time to fix it so all stays fine and looks wonderful and stuff.
At least this code will do what you're looking for (I think) - you can work from there to get it nicer as you want.
I will NOT be able to big updates on this anymore, so if you need radical changes, someone else will have to do it - small changes, I can do.

Please remember to click the * below left if this helps

Please Login or Register  to view this content.

Please remember to click the * below left if this helps

[thuff]

Thanks for your response! Unfortunately it didn't work. It did create all the tabs but no data was on any of them. Again, I appreciate you trying!

[JasperD]

On your sample it worked fine.
Please make sure of the following :

- Put the code in the WORKSHEET CODE AREA of worksheet with the name 'Full Report'
- Run the code while the 'Full Report' sheet is the active sheet

Please try again - make sure you don't put the code in a module, but in the worksheet code area of "Full Report"
Thanks

[thuff]

You are fabulous!! I am so glad you recognized my mistake & corrected me. As I said, I have no vba experience so thank you for your patience. It appears to have worked perfectly but I will review it closer in the morning. Thank you again!!!

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

[thuff]

JasperD, you did a fantastic job on this, thanks again! I do have one issue I was hoping you could fix. It didn't create tabs for every different name. 4405BE, 4405BK, & 4405BR are listed on the 4405BR tab, 4405FR & 4405FS are listed on the 4405FS tab, 4405PE & 4405PL are listed on the 4405PL tab, 4405RA & 4405RH are listed on the 4405RH tab and 4405SH is not listed on any tab. Also, I will need to add 2 columns every month, will this code allow for this? For example, it now has Jan (Col.E), Jan $ (Col.F), and Total $ (Col. G). The next month will be Jan (Col.E), Jan $ (Col.F), Feb (Col.G), Feb $ (Col.H), and Total $ (Col. I) and so on. Being a newbie, I am hoping those are very minor issues.