Insert Row in Two Worksheet

daneeds

New Member
Joined
Feb 6, 2004
Messages
6
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.
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,102
Messages
5,768,104
Members
425,454
Latest member
khoro

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top