I am trying to link 2 different spread sheets.
sheet 1 contains address details (postcode) & order information.
sheet 2 contains post code & shipping dates (sorted by post codes)
what i would like to do is use the post code from sheet 1 and compare to sheet 2 ...then pull the shipping dates from sheet 2.. This will then fill a field on the label.
this can be seen a either 2 different excel work books .. or both sheets in the 1 work book.
thank you for your help.