What progression do you want for Column F?

You're showing
F1
F6
F14

Is that a typo?

If not, what's the next couple of references?
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------


"OTS" wrote in message
ups.com...
hi there, i need some help using offset.

on sheet 1, i have a table of data. on sheet 2, i manually pick a cell
and reference it to some cell in sheet 1. say for example, in sheet 2,
A1='Sheet1'!F1. what i want is that when i choose A1, A2 will have some
formula making it equal to 'Sheet1'!F6 and A3 will be equal to
'Sheet1'!F14. it seems like i should be using offset for this but i
don't know how to offset from another worksheet.

any help will be appreciated. thank you.