To paste link or to =cell ref??
 

Please could someone explain to me the difference between using the paste
link function & the €œ= cell ref€� function to link cells between workbooks. (I
find link paste useful as I can link large numbers of cells at one time where
as I have to use the €œ=€� method for each cell. Maybe there is a way to do
large numbers of cells with the €œ=€� method?)
Thanks

To paste link or to =cell ref??
 

There is not relly a quick way in using the "= cell ref". But if you do use
the "=Cell Ref" method, whn you copy this to another cell, the cell ref
changes in repect to its placing. This may help you, by copying the "=Cell
Ref" to the other cells, and by using the $ either in front of the Column
Number / Row Number / Or both will determine on how the cell ref changes when
being copied to another cell.

Hope This Helps

"FTM" wrote:

Please could someone explain to me the difference between using the paste
link function & the €œ= cell ref€� function to link cells between workbooks. (I
find link paste useful as I can link large numbers of cells at one time where
as I have to use the €œ=€� method for each cell. Maybe there is a way to do
large numbers of cells with the €œ=€� method?)
Thanks

To paste link or to =cell ref??
 

Thanks that does help. Are you able to explain the difference between the two
tools?
Cheers
F

"fluffymoore" wrote:

There is not relly a quick way in using the "= cell ref". But if you do use
the "=Cell Ref" method, whn you copy this to another cell, the cell ref
changes in repect to its placing. This may help you, by copying the "=Cell
Ref" to the other cells, and by using the $ either in front of the Column
Number / Row Number / Or both will determine on how the cell ref changes when
being copied to another cell.

Hope This Helps

"FTM" wrote:

Please could someone explain to me the difference between using the paste
link function & the €œ= cell ref€� function to link cells between workbooks. (I
find link paste useful as I can link large numbers of cells at one time where
as I have to use the €œ=€� method for each cell. Maybe there is a way to do
large numbers of cells with the €œ=€� method?)
Thanks

To paste link or to =cell ref??
 

Im Afraid I can't as i don't use the paste link. But When if you "=Cell Ref"
belongs to another worksheet of file that your formula belongs to, then this
will automatically create a link between the two.

"FTM" wrote:

Thanks that does help. Are you able to explain the difference between the two
tools?
Cheers
F

"fluffymoore" wrote:

There is not relly a quick way in using the "= cell ref". But if you do use
the "=Cell Ref" method, whn you copy this to another cell, the cell ref
changes in repect to its placing. This may help you, by copying the "=Cell
Ref" to the other cells, and by using the $ either in front of the Column
Number / Row Number / Or both will determine on how the cell ref changes when
being copied to another cell.

Hope This Helps

"FTM" wrote:

Please could someone explain to me the difference between using the paste
link function & the €œ= cell ref€� function to link cells between workbooks. (I
find link paste useful as I can link large numbers of cells at one time where
as I have to use the €œ=€� method for each cell. Maybe there is a way to do
large numbers of cells with the €œ=€� method?)
Thanks

To paste link or to =cell ref??
 

Thanks, yes I've tried to compare the two methods side by side to find the
difference (I know this seems daft but I really want to know if we have to
ways of doing the same thing or if one is more suited to a situation than
another) so far the only thing I can find is that the paste link method gives
an absolute cell ref whereas the = method gives a relative reference. They
both update the same & link between workbooks the same as far as I can tell.


"fluffymoore" wrote:

Im Afraid I can't as i don't use the paste link. But When if you "=Cell Ref"
belongs to another worksheet of file that your formula belongs to, then this
will automatically create a link between the two.

"FTM" wrote:

Thanks that does help. Are you able to explain the difference between the two
tools?
Cheers
F

"fluffymoore" wrote:

There is not relly a quick way in using the "= cell ref". But if you do use
the "=Cell Ref" method, whn you copy this to another cell, the cell ref
changes in repect to its placing. This may help you, by copying the "=Cell
Ref" to the other cells, and by using the $ either in front of the Column
Number / Row Number / Or both will determine on how the cell ref changes when
being copied to another cell.

Hope This Helps

"FTM" wrote:

Please could someone explain to me the difference between using the paste
link function & the €œ= cell ref€� function to link cells between workbooks. (I
find link paste useful as I can link large numbers of cells at one time where
as I have to use the €œ=€� method for each cell. Maybe there is a way to do
large numbers of cells with the €œ=€� method?)
Thanks