Fill Values in Cells to the right

[excelexpert1973]

Hi

I have posted this erroneously in excel programming. Sorry for posting
in 2 separte groups.

I am using the illustration below to explain my problem.


1 2 3 4 5 and so on

1 "Val1"
2 "Val2"
3 "Val3"
4
5


In another cell, I have a value "say" 6. In the first row, I want
"Val1" to be copied from Column 2 to Column 6 (6 entries). By the same
logic, in ROW 2, "Val2" will be copied from Column 3 to Column 7.

Is there a way of doing this using formulae or function?


Best Regards
Prasad

 

[ryguy7272]

If your data is all in Column A, try this in Cell B1:
=INDIRECT("a"&COLUMN()+-1)

Alternatively, try this in Cell B1:
=OFFSET($A$1,COLUMN(A1)+ROW(A1)-2,)


Hope it helps.
Ryan--

 

[excelexpert1973]

If your data is all in Column A, try this in Cell B1:
=INDIRECT("a"&COLUMN()+-1)

Alternatively, try this in Cell B1:
=OFFSET($A$1,COLUMN(A1)+ROW(A1)-2,)

Hope it helps.
Ryan--

--
RyGuy












- Show quoted text -

Thanks for your inout Ryan.

 

[ryguy7272]

If it helped, please click the "Yes" button.
Thanks,
Ryan--