I need Help with MS Excel!!

[JSFLY]

Hey guys

Quick Excel Question. Lets say I have 2 workbooks open. I want to be able to take a cell from workbook1 and have it linked to workbook2. That way, when I change the number in the cell in Workbook1, its linked to workbook2 and the number in workbook 2 would change as well. Anyone know how to do this?

Thanks

 

[WW]

the workbook name goes in brackets, then the worksheet name and an exclamation point:

enter this in the 2nd open workbook to link:

=[Book1]Sheet1!$A$1

 

[JSFLY]

cool thanks!