E
EE
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
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