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:
=Sheet3!L3
=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?
Bookmarks