Newbie Relative Reference Question

I am a newbie to Macro's and VBA code and could use some help with what I assume is a relatively easy question.

I want to have a macro code that I can tie to multiple macro buttons without having to have multiple macro's. What I am trying to do is have a button that says "COPY" and that button will copy whatever is to the right of it (move 7 cells to the right and then copy a range of 124 rows to the right). I would like to have a paste button that would paste that range over the same cells of a different row.

My goal is to have a copy button and a paste button in columns a and b for every row of data that way someone could hit the copy button and copy all the data for a promotion and click the paste button to paste it in a different promotion.

Please help.

I don't understand, is this too easy of a problem to help with?

I'm not a VBA guy but look into Application.Caller and Offset and Resize.