Insert Row In Worksheet One and do the same in worksheet 2

[timarcarze]

Hi all,

Spent some time trying to fix this issue to no avail. Hope someone can help!

Basically, I've attached a spreadsheet with 2 worksheets, "Summary" and "Detailed".

I would like to create a macro in "Summary" that enables me to insert a row at any position (e.g. insert row to Project 1 - 'above row 12'). While inserting the row, I would like to copy the formulas represented in cells "G:I" (e.g. G8:G11). Cell H11 and I11 both have vlookup formulas that lookup in "Detailed". However, upon inertion of row in "Summary", need to insert 25 rows in "Summary", while copying the cells G6:G31 within respective area of Summary.

My purpose is to set this spreadsheet up, so if anyone wants to insert a task or project to the summary area, they can do so with the click of a button and does not compromise any of the formulas.

Also note, I have code within the sheet that colours the cels within "Summary" "G:I" based on selections. I would like to ensure this is updated as well based on insertion of rows.

I really hope this makes sense!

This forum has been great!
T