Question by  bakerdenn (65)

How do you link two excel spreadsheets based upon cell values?

I need to have three excel spreadsheets linked together and have the values in cells dependent on the values in cells on a different sheet.


Answer by  worker8121 (244)

When you open a formula to edit, excel will automagically create the correct links to any excel sheet you click into, even in a differn't file. Avoid linking between books.


Answer by  SashaDarkCloud (5764)

If you want to link to a data sheet that has similar values and want to only updated on, you enter this formula. =[Bookname. xls]Sheet1! $c$15. Replacing the name of the book, sheet number, and cell information with what you need.


Answer by  worker8388 (994)

You can use Vlookup function to link the sheets. From spreadsheet1 call the spreadsheet dynamically using vlookup function. It should match the criteria.


Answer by  japratt (1687)

You will first have to open up both of the different programs. Next you will have to click, hold, and drag the files.

You have 50 words left!