Macro that selects the cell next to clicked button

JB - Oct 31, 2016 at 12:46 AM
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.