Fill Values in Cells to the right
 

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

Fill Values in Cells to the right
 

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


" wrote:

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

Fill Values in Cells to the right
 

On Nov 5, 10:07 pm, ryguy7272
wrote:
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



" wrote:
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- Hide quoted text -

- Show quoted text -

Thanks for your inout Ryan.

Fill Values in Cells to the right
 

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


" wrote:

On Nov 5, 10:07 pm, ryguy7272
wrote:
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



" wrote:
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- Hide quoted text -

- Show quoted text -

Thanks for your inout Ryan.