I have added a few shapes to my worksheet. I have assigned macros to them. But I had to create separate macros for all.
Is there a way for excel to recognize which shape was clicked and based on its text value find the cell to copy. That way I need not have to create separate macros for each shape.
I have tried searching for it online, found a few things which I tried but did not work.
Any help would be greatly appreciated.