Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
Importing information from 2 workbooks into a 3rd one
Hi, I need some help with importing information from 2 different workbooks
into a third one. The problem that I have is the following: the reference points from where the information needs to be pulled from are not the same cells every day but information in column A that point to the information in column B in the same row that need to be pulled into the 3rd workbook. In Detail: in ressource workbook 1 I have the order # in column A and shipping information for each order # in column B. Those shipping information for each order # need to be pulled into the 3rd workbook in which the order # of workbook 1 are part of a bigger list; and this list of order # is changing every day. So I need a formular for importing data which says if you find the same value in column A in workbook 1 and workbook 3, than pull information from workbook 1, column B same row into workbook 3 column G same row something like that. Who can help me with that? Every imput is very much appreciated. |
#2
Posted to microsoft.public.excel.links
|
|||
|
|||
Importing information from 2 workbooks into a 3rd one
"Susanneec" wrote: Hi, I need some help with importing information from 2 different workbooks into a third one. The problem that I have is the following: the reference points from where the information needs to be pulled from are not the same cells every day but information in column A that point to the information in column B in the same row that need to be pulled into the 3rd workbook. In Detail: in ressource workbook 1 I have the order # in column A and shipping information for each order # in column B. Those shipping information for each order # need to be pulled into the 3rd workbook in which the order # of workbook 1 are part of a bigger list; and this list of order # is changing every day. So I need a formular for importing data which says if you find the same value in column A in workbook 1 and workbook 3, than pull information from workbook 1, column B same row into workbook 3 column G same row something like that. Who can help me with that? Every imput is very much appreciated. you might want to use microsoft access and import both tables with the order number being the key field, then run a query. |
#3
Posted to microsoft.public.excel.links
|
|||
|
|||
Importing information from 2 workbooks into a 3rd one
Thank you, will try that.
"ashaback" wrote: "Susanneec" wrote: Hi, I need some help with importing information from 2 different workbooks into a third one. The problem that I have is the following: the reference points from where the information needs to be pulled from are not the same cells every day but information in column A that point to the information in column B in the same row that need to be pulled into the 3rd workbook. In Detail: in ressource workbook 1 I have the order # in column A and shipping information for each order # in column B. Those shipping information for each order # need to be pulled into the 3rd workbook in which the order # of workbook 1 are part of a bigger list; and this list of order # is changing every day. So I need a formular for importing data which says if you find the same value in column A in workbook 1 and workbook 3, than pull information from workbook 1, column B same row into workbook 3 column G same row something like that. Who can help me with that? Every imput is very much appreciated. you might want to use microsoft access and import both tables with the order number being the key field, then run a query. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2 Books, importing information Excel | Excel Discussion (Misc queries) | |||
Linking workbooks in Excel | New Users to Excel | |||
Importing relative positoin information | Excel Worksheet Functions | |||
Consolidate different sheets to different workbooks | Excel Worksheet Functions |