AriffChowdhury
New Member
- Joined
- Jul 28, 2013
- Messages
- 10
Hello,
I have string in column A.
I input some numerical values (null -15) in column B .
I want vba / function to look for the value entered in B and based on this value fill the adjcaent columns with string in column A by adding "_C" & "number" with the string in column A
For example;
I have string in cell A1 "volume1".
I input value 3 into cell B1.
I want concatenate the string of column A with "_C" & "number", and fill the adjcent no. of column based on the value.
I want "volume1_C1" in column C1, "volume1_C2" in D1 and "volume1_C3 in E1
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col span="5" style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>
</tbody>
Does this make sense ? and is this can be achieved through vba/excel function ? i would prefer vba..
Thank you!
I have string in column A.
I input some numerical values (null -15) in column B .
I want vba / function to look for the value entered in B and based on this value fill the adjcaent columns with string in column A by adding "_C" & "number" with the string in column A
For example;
I have string in cell A1 "volume1".
I input value 3 into cell B1.
I want concatenate the string of column A with "_C" & "number", and fill the adjcent no. of column based on the value.
I want "volume1_C1" in column C1, "volume1_C2" in D1 and "volume1_C3 in E1
A | B | C | D | E | F | G | H |
Headers | Values | Header1 | Header2 | Header3 | Header4 | Header5 | Header6 |
Volume1 | 3 | Volume1_C1 | Volume1_C2 | Volume1_C3 | |||
Volume2 | |||||||
Volume3 | 5 | Volume3_C1 | Volume3_C2 | Volume3_C3 | Volume3_C4 | Volume3_C5 | |
Volume4 | |||||||
Volume5 | |||||||
Volume6 | 1 | Volume6_C1 | |||||
Volume7 |
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col span="5" style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>
</tbody>
Does this make sense ? and is this can be achieved through vba/excel function ? i would prefer vba..
Thank you!