Hi guys, I'm very new to VBA so please be gentle.
I've got a spreadsheet that has 3 sheets, the first sheet has several cells with formulas in that reference cells on the other 2 sheets.
Some of these formulas look as follows:
=IF(ISBLANK(Sheet3!DJ3),"Unable to Provide","")
And so on...
What I need is a Macro that I can link to a Command button so that every time the button is pressed, the 'row' reference in each of the formulas increases by one.
Can anyone point me in the right direction please?