By "worksheet" do you actually mean "workbook" which contains worksheets?
See help on "linking to other workbooks"
If you mean worksheet then see David's reply.
Basically the same except you would be linking sheet references from two
workbooks.
=[Workbook1.xls]Sheet1!$A$1
Gord Dibben MS Excel MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
