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

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.