Excel: Add/Remove rows with formatting Macro

Hello, I've been trying to piece a macro together from a couple different sites but haven't been able to find a solution for what I'm looking to do. I have an excel doc to track paint emissions per week as well as keep track yearly and monthly totals. I would like to add rows across all 60 some sheets in the spot above the button location while copying all the formatting in the cell above the new row. Additionally I would also like to add a button that will prompt the user for which row they would like to delete and remove it from all sheets. I certainly appreciate any help, hopefully this will be the last step and I can be done with this document for a while! ~BluOx

This question generated 58 answers. To proceed to the answers, click here.

This thread is current as of August 18, 2014.

For more resources for Microsoft Excel