referencing a different workbook

cjousma

New Member
Joined
Sep 26, 2006
Messages
2
ok i have 2 workbooks. i have one to record data and one is a listing of all the standard output that should be achieved.

in my data recording workbook i have a column for a part number which i look at the other workbook and have to manually type in the standard output from the other workbook.

i was wondering if there was a way that i could have it so when i type in the part number the standard output would automatically fill in by having it be retrieved from the other workbook.

if anyone could give me an example or walk me through this that would be appreciated. i dont know if i explained it that well either but any help is appreciated.

Thanks,

Chad Jousma
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

dave3009

Well-known Member
Joined
Jun 23, 2006
Messages
7,004
Office Version
  1. 365
  2. 2016
Hi cjousma.

in your output workbook go to the cell you want the data in then type the = sign>>activate you input workbook then click on the cell you want to copy over. You'll get something that looks like

='[output.xls]sheet1'!$A$1

then when you save or close the workbooks the full path name will update


HTH


Dave
 

stemar

Board Regular
Joined
Mar 16, 2002
Messages
248
Hi,

In a similar situation I used this formula to look up information about a member of staff. I took this from cell E6 of my spreadsheet.

=IF($C6="","",VLOOKUP($C6,Personnel.xls!Personnel_List,4,))

where $C6 is a cell in the row of my spreadsheet where the name is. The if(... is just to make the cell blank if there isn't a name in column C.

Personnel.xls is the name of the other file and Personnel_List is a named range within Personnel.xls. The info I want is in the 4th column of Personnel_List

HTH
 

cjousma

New Member
Joined
Sep 26, 2006
Messages
2
thanks for the replies but thats not exactly what i am looking for. is there a way i can paste an image of the workbooks in here so i can show you what i am looking at. i am not that great at explaining things and it would be better if i could show you what i am looking at so you know exactly what i am asking. thank you.
 

Forum statistics

Threads
1,136,262
Messages
5,674,709
Members
419,521
Latest member
Jasonnie

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top