Excel Adding Rows across pages

Closed
erin_ASM
Posts
1
Registration date
Sunday June 14, 2009
Status
Member
Last seen
June 15, 2009
- Jun 15, 2009 at 01:21 PM
 erin - Jun 17, 2009 at 07:44 AM
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

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Jun 15, 2009 at 08:54 PM
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.
0
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!
0
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Jun 16, 2009 at 06:01 AM
use the same tactics. shift+tabs one by one and insert row.
0
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jun 16, 2009 at 06:07 AM
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
0

Didn't find the answer you are looking for?

Ask a question
Thanks!
0