G Guest Dec 3, 2004 #1 How to you get one cell in a workbook to equal another cell in a completely different workbook?
J JE McGimpsey Dec 3, 2004 #2 The easiest way. With both workbooks open, type "=" in the cell you want to contain the reference. Switch to the target workbook and click in the cell that you want to reference. The formula bar will now have something like =[CompletelyDifferent.xls]Sheet1!A1 Type Enter. XL switches back to the first workbook. You can now close the other workbook - XL will then display the path as well as the file name in the reference. Of course, you could type in the reference directly, now that you've seen the format.
The easiest way. With both workbooks open, type "=" in the cell you want to contain the reference. Switch to the target workbook and click in the cell that you want to reference. The formula bar will now have something like =[CompletelyDifferent.xls]Sheet1!A1 Type Enter. XL switches back to the first workbook. You can now close the other workbook - XL will then display the path as well as the file name in the reference. Of course, you could type in the reference directly, now that you've seen the format.
