I have a button that runs a macro taking data from the active sheet and
putting it in a separate summary sheet and then printing the summary sheet. I
want to put a button on every sheet in the workbook that will do the exact
same thing - take the data from that sheet, put it on the summary sheet and
then print the summary sheet. How do I copy the button and the macro so that
it will work on each sheet?
Note: the macro begins by clearning out the summary sheet so the new data
gets put into a clean worksheet.
Thanks for your help.