Excel Adding Rows across pagesClosed

Question

Hello,
I was wondering how I could add a row in one page that would automatically add a row on the next page. I'm guessing this is done using a macro. Any insight you could provide would be of great help. Thanks!

Erin

venkat1926 · Answer

there is no need for macro 
for e.g.m all the sheet there are numbers in A1, B1 and C1 

pressing shift key click tabs of al the sheets one by one  
and in any sheet in front of you type in D1
=sum(a1:C1) and hit enter 
CLICK TAB OF ANY SHEET.  

Now see all the sheet whether you get what you want.

Erin · Answer

I actually meant adding a row like inserting a row. Not adding values. Sorry if I was unclear. I need to insert a row on one page and have that automatically insert a row of another page. Thanks!

venkat1926 · Answer

use the same tactics. shift+tabs one by one and insert row.

Excelguru · Answer

Hi erin_ASM
select all the sheets first and then insert a row in any of the sheets
This will insert a row in all the worksheets at the same location

erin · Answer

Thanks!

Excel Adding Rows across pages

5 responses

Similar discussions

Subscribe To Our Newsletter!