Linking 2 .xlxs files to pull filnal DB field
HI,
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.
rob
-
If you add a 2nd database then the Joining table box will appear and you need to configure this to tell it that field 4 in the first table is the same as field 9 in the 2nd for example
0 -
Hi Peter,
Thank you for the tip, that worked great. my test data was able to complete the query and fill the table field on the label.
with that success, the team has come back with an extension to the original request.. with now 4 different sheets in the same work book.
all with the same headings, but for each state in question
i recognize that i need to bring the tables in. but fail at the Join stage..
the aim is to basically have the 4 pages joined as one, and then search via postcode and pull out the service area
0
Iniciar sesión para dejar un comentario.
Comentarios
2 comentarios