Hello, I am new to the forums, and starting to learn VBA. Great Site. I have a question, some help would be much appreciated.
What I am doing is, on Sheet 1, I have a column [A1:A10} containing values [1-10]. On Sheet 2, I take each element of the Sheet 1 column, and multiply by 2(or do another fxn), and place the result right next to the Sheet 1 Column so it should look something like this:
A B
1 2
2 4
3 6
4 8
5 10
6 12
...
10 20
The function I will be using on Sheet2 is actually different, I am just using x2 to better understand how to write it. I think I will need to do a loop, but I am quite unsure on some of the details.
What I am doing is, on Sheet 1, I have a column [A1:A10} containing values [1-10]. On Sheet 2, I take each element of the Sheet 1 column, and multiply by 2(or do another fxn), and place the result right next to the Sheet 1 Column so it should look something like this:
A B
1 2
2 4
3 6
4 8
5 10
6 12
...
10 20
The function I will be using on Sheet2 is actually different, I am just using x2 to better understand how to write it. I think I will need to do a loop, but I am quite unsure on some of the details.