Hi all! I have managed to create a command button which will jump to the next empty cell in a column. However I then need it to also copy the formula from the cell above whilst keeping the relative cell references. For example, of the empty cell is E5, and the formula in D5 is =LookUpLists!K28, how do I copy the formula to E5 so that it is =LookUpLists!K29?
I have tried a few codes so far but they all seem to copy the formula exactly rather than as a relative reference.
Apologies I can’t copy and paste any of my code due to writing this on my phone and not my laptop.
Thank you.
I have tried a few codes so far but they all seem to copy the formula exactly rather than as a relative reference.
Apologies I can’t copy and paste any of my code due to writing this on my phone and not my laptop.
Thank you.