Linking Values in Worksheets

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
 
F

Frank Kabel

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

Frank
 
A

Arvi Laanemets

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.
 
G

Guest

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
 
A

Arvi Laanemets

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
 
F

Frank Kabel

Hi if you remove the last $ sign it will change the formula then copied
down

Frank
 
Top