Hey folks. Looking to make a very basic macro, but my VBA skills are below basic!
Essentially, I want a macro that when used will set the currently selected cell to reference to the cell I most recently edited. So for example, after I complete the sum in C9, I want to go to cell A1, run my macro, and have A1 generate the formula linking it to cell C9.
<tbody>
</tbody>
The main challenge I think will be trying to get the references to work across tabs (e.g. adding in the !sheet references when needed). Any pointers you can provide would be much appreciated!
Essentially, I want a macro that when used will set the currently selected cell to reference to the cell I most recently edited. So for example, after I complete the sum in C9, I want to go to cell A1, run my macro, and have A1 generate the formula linking it to cell C9.
=C9 | 5 | |
4 | ||
=SUM(C1:C3) |
<tbody>
</tbody>
The main challenge I think will be trying to get the references to work across tabs (e.g. adding in the !sheet references when needed). Any pointers you can provide would be much appreciated!