ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Linking worksheets (https://www.excelbanter.com/excel-worksheet-functions/55035-linking-worksheets.html)

Linking Blank Cells

Linking worksheets
 
I am linking a cell in 1 worksheet to a specific cell in another worksheet,
both within the same work book. The cell I am linking from is blank, but when
I link it to the other work sheet it shows up as the number zero. How do get
the recieving cell to show exactly what is in the sending cell?

Peo Sjoblom

Linking worksheets
 
You need to use a formula

=IF(linked_cell="","",linked_cell)


--

Regards,

Peo Sjoblom


"Linking Blank Cells" <Linking Blank wrote
in message ...
I am linking a cell in 1 worksheet to a specific cell in another

worksheet,
both within the same work book. The cell I am linking from is blank, but

when
I link it to the other work sheet it shows up as the number zero. How do

get
the recieving cell to show exactly what is in the sending cell?





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

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