Excel Adding Rows across pages

[Closed]
Report
Posts
1
Registration date
Sunday June 14, 2009
Status
Member
Last seen
June 15, 2009
-
 erin -
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

5 replies

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
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.
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!
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
use the same tactics. shift+tabs one by one and insert row.
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
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