One play ..

Assume you have in A1:L1 : Jan, Feb, Mar, etc

Let's reserve say, cell A7 for the input of the starting cell
Enter in A7: A1

Now put in A8:
=OFFSET(INDIRECT($A$7),,COLUMNS($A$1:A1)-1)

Copy A8 across to L8
A8:L8 will returns what's in A1:L1

Change the input in A7 to: C1
A8:L8 will now return what's in C1:N1,
viz: Mar, Apr, May, ... etc
(i.e. shifts the "starting" cell to C1 instead)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jon C" wrote in message
...
Hi,

I'd like to be able to do an offset from a reference in another cell.
Help...

Here's what I really mean.

A1 contains 'January'
B1 'February'
Etc


A8 = A1, B8 = B1, etc.

Dead easy.

What I'd like to do is change A8 to say C1, for March, and for the
remainder
of the cells on row 8 to automatically follow in line i.e. B8=D1, etc.

Thanks,

Jon