Duplicating Multiple Buttons Adjusting Target Cell Automatically

Hello All,

I tried to search the forum for my unique problem but had no luck. As you will see attached, I have a series of excel buttons I need to duplicate and have target a different set of cells. I am hoping there is a way to avoid manually doing this.

The goal of the document is to push the button when both colours in the row and column interact (research on birds). There are two additional behaviours with an exact same set of buttons but they need to target "Body Rush" and "Food Displacement" tables underneath. I need all the buttons on one page since multiple behaviours happen simultaneously that need to be recorded.

I have something like 100+ modules in VBA I have created, I am hoping there is an easier way to do this so I don't have to create another ~200 modules in order to get the last two behaviours setup.

I am hoping there is either an easier button system or way to make buttons adjust somehow.

I am not the most advanced VBA user but I appreciate any advice you can provide me or direction you can point me in. Thank you.

I can learn quickly but I'm not very familiar

hi HDTV, welcome to ExcelForum, please check attachement, press the buttons

I've done it only for Head Tilt. If you advise what do you need for the other two tables I would help or you can make it on your own

I forgot to say thank you! I really appreciate it!

Thanks for the help! VBA is definitely a world I need to get better at!