I need to run a macro on the cell directly to the right of the button I clicked to run it
I will be running that macro on around 100 buttons down the spreadsheet so do not want to have to create a new macro for each one.
While the macro is running it also copies values from a specific cell, that cell does not change regardless of which of these buttons is pushed, so how do I run absolute and relative in the same macro.
Can someone help because i'm not a VBA boffin and I'm doing my head in.
Macro that selects the cell next to clicked button