ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Cell reference Issue (https://www.excelbanter.com/excel-worksheet-functions/147063-cell-reference-issue.html)

Jerry Foley

Cell reference Issue
 
How do I reference cell F52 on worksheet "Vocie & Cable Installation" while
in a another worksheet in the same work book?

Thanks

Roger Govier

Cell reference Issue
 
Hi Jerry
='Voice & Cable Installation'!F52

or better still, type = then navigate to cell F52 on the worksheet Voice
and Cable, and press Enter.
Excel will complete the entry the same as above.

--
Regards

Roger Govier


"Jerry Foley" wrote in message
...
How do I reference cell F52 on worksheet "Vocie & Cable Installation"
while
in a another worksheet in the same work book?

Thanks




JLatham

Cell reference Issue
 
My post here explains how to do that:
http://www.microsoft.com/office/comm...0-9f80c70ce35f



"Jerry Foley" wrote:

How do I reference cell F52 on worksheet "Vocie & Cable Installation" while
in a another worksheet in the same work book?

Thanks



All times are GMT +1. The time now is 01:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com