Insert Row in Two Worksheet

[daneeds]

Is there a way to insert a new row in Sheet1 and Sheet2 simaltainously? For example: in Sheet1 insert new row between row 9 and row 10 and Sheet2 automatically updates (by macro?) with this same action. The insertion point needs to be the same in both worksheets. Thank you DanE Oakland, California.

 

[Andrew Poulsom]

Click the tab of the first worksheet the Ctrl+Click the tab of the second. Then insert your row. Click any tab other than the active one (bold) to exit Group mode. Do this before you do anything else otherwise everything will be done on both worksheets.

 

[daneeds]

Thank you. This solution will work for me.