Hi

Thandk for the help. I am using the illustration below to explain my
problem.

1 2 3
4 5 6 7 8 9

1 "Value1"

2 "Value2"

3
"Value3"

4

5

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

Is there a spreadsheet function way of doing this? I am posting this
here because if there is no spreadsheet way of doing this, a macro or
a function will be a great help.

(If it is a macro solution) is it possible to set an End Column. Lets
assume I set end column as "20". Then even if I run macro to value in
Row 18, it will copy formula only till Column 20 (and not till 23 if
we go by the logic above)

Best Regards
Prasad