ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating multiple links between worksheets within a single workboo (https://www.excelbanter.com/excel-discussion-misc-queries/220446-creating-multiple-links-between-worksheets-within-single-workboo.html)

castateemployee

Creating multiple links between worksheets within a single workboo
 
I need to link specific cells in one worksheet to other entire worksheets
within a single workbook. Is that even possible? Thank you.

JBeaucaire[_121_]

Creating multiple links between worksheets within a single workboo
 

Just add a reference to the sheet along with the cell reference wanted.

=Sheet1!A2

Place that formula in a cell on Sheet2 and the value from sheet1 will
appear.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=62797



All times are GMT +1. The time now is 04:44 PM.

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