Excel Help Please

ttt

vlookup?

thanks modk, i will try figure it out with vlookup

=sum(sheet1!M:M)

That will keep you going for about 60,000 lines.

thanks jedy but that won't work because I don't want the sum of the values, I want the lsat inputted value

Ah ok, sorry misunderstood. It's got me thinking though...

i know mate, its doing my head in but i will figure it out

dlarssonf
i know mate, its doing my head in but i will figure it out

Have you worked out? If not then what type of data is in the cells you want to track?

no mate, being honest i left it last night as it was annoying me lol. The numbers are currency figures

Is sheet1 updated via a web query ?

=INDIRECT("M"&COUNTA(M:M))

forgive if im missing something here but i have a similar spreadshhet that i use every day which downloads values. in my sheet to i simply enter

="(sheet 1 name)"!m1

in d10 and as long as you have sheet 1 open, the d10 in sheet 2 will always show what is in the sheet 1 m1. like i say i must be missing something cause this seems far too simple

=INDEX(Sheet1!M:M,MATCH(1E+30,Sheet1!M:M))

fkqmz, it's not m1 he wants every time. It's the last nonblank cell in column m.

Bay Jesus, your solution is probably better as it will take into account if any cell in column m is blank.

sorry lads I was away for a bit there, no one sheet is updated by myself manually and I want the other to update automatically. I am a bit busy fot the next couple of hrs but will give the suggestions a go,

Many thanks to all!!!!