Please help, im stuck.
I receive an email with a spreadsheet every week from that email I need to import inv no, consignment no, total charge, and cb invoice notes from sheet (1) into sheet (2) according to either the consignment no or cb invoice note no.
is there a relatively straight forward way to do this?
many thanks
colin
You already have the consignment number in the 2nd file. So what data should be imported?
Cheers,
Arlette
If I 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]
Sorry arlette, ive got it the wrong way round i need to import from sheet 2 into 1. off to a good start!!!
I need to import the following based on consignment no:-
invoice no(2) into carrier inv no(1)
total charge(2) into cost(1)
cb invoice note(2) into reference(1)( dont suppose it matters if it overwrites)
Kind regards
colin
Your files got lost during the upgrade. Can you please re-attach?
Cheers,
Arlette
If I 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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks