Hi,
I am wanting any help please. I need some help to speed up days worth of calculations by making a macro that will automatically provide a helper column with preset formulas on the first column that is empty. It will probably need an input box asking which column and row that I will be referencing as this may change. Generally my data starts in row 3 with row 2 as the header.
For example if choosing column A the macro will automatically create a helper column with the preset formula in the first empty column which is C:
<tbody>
</tbody>
Or if choosing column B the macro will create a helper column in C with the preset formula:
<tbody>
</tbody>
I assume I have to create a loop in the range and go down the row but I am far out of my depth.
Any help is appreciated!
Thanks
I am wanting any help please. I need some help to speed up days worth of calculations by making a macro that will automatically provide a helper column with preset formulas on the first column that is empty. It will probably need an input box asking which column and row that I will be referencing as this may change. Generally my data starts in row 3 with row 2 as the header.
For example if choosing column A the macro will automatically create a helper column with the preset formula in the first empty column which is C:
A | B | C | |
1 | |||
2 | Car (mins) | Truck (mins) | |
3 | 12 | 15 | =A3*15 |
4 | 10 | 18 | =A4*15 |
5 | 6 | =A5*15 | |
6 | 8 | =A6*15 |
<tbody>
</tbody>
Or if choosing column B the macro will create a helper column in C with the preset formula:
A | B | C | |
1 | |||
2 | Car (mins) | Truck (mins) | |
3 | 12 | 15 | =B3*15 |
4 | 10 | 18 | =B4*15 |
5 | 6 | ||
6 | 8 |
<tbody>
</tbody>
I assume I have to create a loop in the range and go down the row but I am far out of my depth.
Any help is appreciated!
Thanks