Linking Values in Worksheets

  • Thread starter Thread starter DavidM
  • Start date Start date
D

DavidM

Is there a simple method of linking a column of values in
one worksheet to another worksheet?
I can do it manually, one at a time but is there a way of
copying the link down the column?
(The columns are identical in length)
Registers\[Stock Control-Sigma-SMTech.xls]Sheet1'!$C$1369
Registers\[Stock Control-Sigma-SMTech.xls]Sheet1'!$C$1370
Registers\[Stock Control-Sigma-SMTech.xls]Sheet1'!$C$1371
etc, etc

Many thanks

david
 
Hi David
try
='C:\Registers\[Stock Control-Sigma-SMTech.xls]Sheet1'!$C1369
and copy down

Frank
 
Hi

In another workbook or on another worksheet?

By your example, it's workbook
To link some cell in target workbook and cell C1369 in source workbook:
='C:\My Documents\Registers\[Stock Control-Sigma-SMTech.xls]Sheet1'!C1369
And copy the formula down/up to get rest of cells linked.
 
Hi Chaps
Yes it was workbook :-(

Thanks for the response but that doesn't work - it simply
copies the first formula keeping the cell information
first entered. I need to get the last figure to change as
it copies down - like selecting a sequence of numbers and
getting them to continue (as per simple Excel actions)

cheers

david
 
Hi

Are you sure you used relative reference (without $'s)
When yes, then maybe you have set calculation to manual - press F9 to
enforce the recalculation
 
Back
Top