Linking Values in Worksheets

[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

 

[Frank Kabel]

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

Frank

 

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

 

[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

 

[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

 

[Frank Kabel]

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

Frank

 

[Guest]

Wonderful

Thanks very much - everything now works fine.

david