PDA

View Full Version : change cell refernces in MS excel 2003



snowman88
12-12-2006, 07:39 PM
Hi there

I daily update a large excell spreadsheet thgat contains references to other worksheets in the spreadsheet.
The refernces are are all 1 column down at a time (e.g. from ='CH Data'!K107 to ='CH Data'!K108.

Is there a simple way to automate this?

Thanks in advance

Sno

RogerRamjet
13-12-2006, 03:21 PM
Hi Sno

Try this formula;

=INDEX('CH Data'!K:K,MATCH(9.99999999999999E+307,'CH Data'!K:K))

This should return the last value in column K in the worksheet CH Data.

Cheers.

Roger

snowman88
13-12-2006, 08:53 PM
sweet,

thanks. I will give that a go.
At least it wil give me something to start on.

Cheers

Sno