hgb Posted October 4, 2000 Share Posted October 4, 2000 Is it possible to define a formula in one worksheet that references a cell in another worksheet in the same file? Any suggestions will be appreciated! Quote Link to comment
Janis Kent Posted October 5, 2000 Share Posted October 5, 2000 Yes. You would use the following formula = 'name of other worksheet' : cell location in other worksheet basically, after the equals sign (=) you would type in the name of the other worksheet within single quotes, being careful to use upper and/or lower case exactly as the other worksheet is named. then a colon mark and the cell location such as B4 or D2. ------------------ Janis Kent, AIA author WorksTutorial & WorksManual Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.