By looking at your sheet i am understanding that you want the data split based on the entries in the "Vessel" column.
However, you have the sheetnames ending with 1, 2, etc. like CMA CGM QINGDAO1, CMA CGM QINGDAO2. Which data should go in which sheet?
Also, what about sheets for ALIANCA SANTOS, ALIANCA MANAUS, etc?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
The macro is designed to prepare the worksheets for all the vessels except the colored ones. These vessels have no data. But what i need is when the macro automatically prepares worksheets, I want the data besides it also to be filled automatically....Please help me out with this
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks