Dividing one sheet data into multiple sheets, vba question

[Green_Star]

Hi,

Every week I get a file from our vendors, and I have to divide the file into multiple files and sent these multiple files to other departments. The file I get from vendors is huge(like 60 columns and around 1000 rows), and while dividing the data into multiple files there is lot of chance to make errors. And I have to do this every week, so I am trying to automate it. Here below I am giving a sample structure of input file and outpute files. This input file number of rows can be vary, but column structure is always same. I have some experience in writing VBA scripts but I am not expert. I can write/develop if some one gives me an idea , sample code would be great. Thanks in advance.

Master file(input)
----------------------------------------------------------------------------

plan1 option1 description date1 date2 value1 value2 value3 comment1 comment2
plan1 option2 description date3 date4 value4 value5 value6 comment3 comment4
plan1 option3 description date5 date6 value7 value8 xxxxx comment5
plan2 option1 description date7 xxxxx value9 valueA xxxxx xxxxxxxxx comment6
plan2 option2 description date8 date9 valueB valueC valueD comment7 comment8
plan3 option1 description dateA dateB valueE valueF valueG

Above xxxxx means no data, I have trouble showing blank spaces in this forum so I showed it with xxxxx.

Above date is going to be split into several work sheets like following.

Description tab
-----------------
plan1 description
plan2 description
plan3 description


Date tab
-----------
plan1 date1
paln1 date2
plan1 date3
plan1 date4
plan1 date5
plan1 date6
plan2 date7
plan2 date8
plan2 date9
plan3 dateA
plan3 dateB


option2 with comments tab
--------------------------
plan1 comment3 comment4
plan2 command7 comment8

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.