ExcelBanter

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

jolowe

Linking Cells
 


Reitanos

Linking Cells
 
I'm not sure of your exact question, but a link is just a formula that
displays data from a different cell. To create a formula like this
type = as you would any other formula and then click on the cell you
will pulling from. The syntax is different if it is the same sheet, a
different sheet, or a different document, but the = + [click] method
is the same.

Does that answer your question?

On May 15, 12:11 pm, jolowe wrote:



jolowe

Linking Cells
 
Thank you for answering - but I can see I did not make my self clear. I
already have the cells linked - but when there is no data in the originating
cell I get a "0" in the destination cell. The information on this worksheet
changes daily and sometimes there are cells with no originating data - but I
still need them linked because there could be infor mation later in the day.
When I send out the "destination" sheets I do not want the "0's" as they
distracting and confuse the data.
Thanks again for trying to help me solve this

"Reitanos" wrote:

I'm not sure of your exact question, but a link is just a formula that
displays data from a different cell. To create a formula like this
type = as you would any other formula and then click on the cell you
will pulling from. The syntax is different if it is the same sheet, a
different sheet, or a different document, but the = + [click] method
is the same.

Does that answer your question?

On May 15, 12:11 pm, jolowe wrote:




jolowe

Linking Cells
 
I am not sure I am doing this whole discussion thing right - I sent a reply
to your answer to me - but I do not see it posted - did it go through?? I am
now trying again to get this one through.

"Reitanos" wrote:

I'm not sure of your exact question, but a link is just a formula that
displays data from a different cell. To create a formula like this
type = as you would any other formula and then click on the cell you
will pulling from. The syntax is different if it is the same sheet, a
different sheet, or a different document, but the = + [click] method
is the same.

Does that answer your question?

On May 15, 12:11 pm, jolowe wrote:





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

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