copy macro and change row

[Tpeter201811]

Hey all,

I have a macro button at the end of a row that copys and reorganizeds the cells in that row to another sheet for printing. Is there a way that I can copy this action down one row? I have a large database and would like to copy these buttons and macros to the end of each row.

 

[Joe4]

Welcome to the Board!

It seems to me that it might be more efficient to just have one button on your whole sheet, and use an Input Box to prompt the user the enter the row number.