Cell Offset
 

Hi,

Id like to be able to do an offset from a reference in another cell€¦ Help€¦..

Heres what I really mean.

A1 contains €˜January
B1 €˜February
Etc


A8 = A1, B8 = B1, etc.

Dead easy.

What Id 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

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

Hi Jon,

Try in A8 and copied across,

=IF(ISERROR(INDEX($A$1:$L$1,$A$9+COLUMN(A1)-1)),"",INDEX($A$1:$L$1,$A$9+COLUMN(A1)-1))

where A9 houses the starting month. if you type 3 then it starts from
March onwards.

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=399003

Thanks Max and Krishnakumar.

Jon C

"Krishnakumar" wrote:


Hi Jon,

Try in A8 and copied across,

=IF(ISERROR(INDEX($A$1:$L$1,$A$9+COLUMN(A1)-1)),"",INDEX($A$1:$L$1,$A$9+COLUMN(A1)-1))

where A9 houses the starting month. if you type 3 then it starts from
March onwards.

HTH


--
Krishnakumar


------------------------------------------------------------------------
Krishnakumar's Profile: http://www.excelforum.com/member.php...o&userid=20138
View this thread: http://www.excelforum.com/showthread...hreadid=399003

Your'e welcome, Jon !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Jon C" wrote in message
...
Thanks Max and Krishnakumar.

Jon C