Insert rows across multiple sheets copy formulas help

Hello everyone. I’m currently using MS Excel 2010 on Windows 7. My question is as follows:

I am looking for help creating a VBA macro within excel. I currently have an excel document with 4 tab worksheets and they are named Completed 2013, Metrics 2013, Completed 2012, and Metrics 2012. What I want the macro to do is insert a row below the selected cell in the Completed 2013 tab then insert a row in the exact same spot in the Metrics 2013 tab and finally drag the formulas from the row above (still in the Metrics 2013 tab) and copy them into the newly inserted row. I’d finally like it to switch the view back to the Completed 2013 tab if possible. As a final note I’d also like to do this for the 2012 tabs but I assume I can just switch the sheet names within the code? Thanks for your help!

This question has been posted on a few other help forums and if I receive an answer there before here I will edit this post to say so.

Hi syt0x. Did you get an answer at another forum on this? Note that people often won't answer a question that has been posted elsewhere, because cross-posters often don't update their posts.

If you haven't got an answer, post back and let me know and I'll take a look. In future I'd suggest you don't post on multiple forums, but instead just pick one and see if someone answers it. You'll almost certainly get a quicker outcome.

I realize that but I've posted on one site before and sat there with no answer for a long while. I need this figured out quickly as my deadline is approaching and I've been struggling with it for a few weeks. I still have not received an answer on any of the sites I posted.

Hello everyone. I’m currently using MS Excel 2010 on Windows 7. My question is as follows:

I am looking for help creating a VBA macro within excel. I currently have an excel document with 4 tab worksheets and they are named Completed 2013, Metrics 2013, Completed 2012, and Metrics 2012. What I want the macro to do is insert a row below the selected cell in the Completed 2013 tab then insert a row in the exact same spot in the Metrics 2013 tab and finally drag the formulas from the row above (still in the Metrics 2013 tab) and copy them into the newly inserted row. I’d finally like it to switch the view back to the Completed 2013 tab if possible. As a final note I’d also like to do this for the 2012 tabs but I assume I can just switch the sheet names within the code? Thanks for your help!

This question has been posted on a few other help forums and if I receive an answer there before here I will edit this post to say so.

I have a document here that would benefit from your Script. I want to insert a Row on Tab 1 and Tab 2 and then copy formula from the above cells (for both tabs), line to be inserted under the cell selected.

Hi ejk3v, it sounds like the exact same thing as what the OP needs to do. You can just make some amendments to the macro to make it work for you. However, I see that you are using a button to run the macro, it this case you may need to select a specific range of cells and insert (instead of the entire row, since inserting a row where the button lies will sort of expand the button's height).

Try something like this, not exactly the best way to select a range of cells but it should work:

Basically this macro will only work when you have worksheet Completed 2013 or Completed 2012 selected. Tested with Excel 2007, should work with 2010 too.

Hi millz,
I hope you are still here on the forums and able to help.
I've used your code to do the same thing that the OP needs - to insert a row on the sheet "Input project data" and have it do the same thing automatically on sheets "Required capacity in hours" and "Capacity Utilization". But for some reason the macro only works for the first two sheets (input project data and required capacity in hours) and doesn't to anything for "Capacity Utilization". Am I doing something wrong? here's the code I have: