thesilkster
Member
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
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