• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

select collection and multi-delivery from one sheet

Good afternoon,
i have been playing around with macros trying to achieve my goal but i am struggling.

i have an TM Export Data sheet that i need to import once a day to into Customer Book to create collection and delivery's, i thought i was doing OK until l noticed that some collections have more than one delivery..

example
Load ID
row 1 Pick 12234 collection
row 2 Drop 12234 delivery
row 3 Pick 12256 collection
row 4 Drop 12256 delivery
row 5 Drop 12256 delivery


this needs to cascade through the book it also needs to break down the date/time separate i did this using INT and MOD
formula

any help is always appreciated

kid regards for your time

arl
 

Attachments

  • Customer Book.xlsm
    79.6 KB · Views: 5
  • TM Export Data.xlsx
    18.5 KB · Views: 5
Back
Top