LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Mr. Snrub
 
Posts: n/a
Default Question regarding inserting rows and data.

In Sheet1 I have the following (from A1 to C3):

2 3 4
3 4 7
8 8 1

In Sheet2 I have the following (from A1 to C3):

=Sheet1!A1+0.001 =Sheet1!B1+0.001 =Sheet1!C1+0.001
=Sheet1!A2+0.001 =Sheet1!B2+0.001 =Sheet1!C2+0.001
=Sheet1!A3+0.001 =Sheet1!B3+0.001 =Sheet1!C3+0.001

....which means that the values displayed in Sheet2 are the following:

2.001 3.001 4.001
3.001 4.001 7.001
8.001 8.001 1.001

Now, suppose I insert a new row enter new data in Sheet1, like so:

2 3 4
3 4 7
1 1 1
8 8 1

Sheet2 looks the same, and the bottom row's formulae are changed to:
=Sheet1!A4+0.001.....=Sheet1!B4+0.001.....=Sheet1! C4+0.001

So, my question is: Is there any way to automatically update Sheet2 so that
it looks like this?

2.001 3.001 4.001
3.001 4.001 7.001
1.001 1.001 1.001
8.001 8.001 1.001

True, I could simply go into Sheet2 and manually insert another blank row
and fill down, but I don't want to have to do that. I only want to work with
Sheet1, I don't want to have to do anything to Sheet2, but I want Sheet2 to
be changed all the same. Understand?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table for survey data w/ questions as Rows & poss answrs as pfwebadmin Excel Discussion (Misc queries) 0 May 17th 05 02:31 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
inserting rows through external data source [email protected] Excel Discussion (Misc queries) 0 April 5th 05 03:16 AM
Searching for data and inserting new rows Kev427 Excel Discussion (Misc queries) 2 February 1st 05 07:15 AM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 12:58 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"