update linked pages
 

I would like to know how to update another worksheet in the very next column
as the main worksheet is updated... Currently when I update rows a1 and a10
on main page, a1 and a10 are updated on the linked page.. What I am looking
to do is update rows a1 and a2 on the linked page when a1 and a10 are updated
on main page.

update linked pages
 

On the linked page
In A1: =main!A1
In A2: =main!A10


"jcdipietro" wrote:

I would like to know how to update another worksheet in the very next column
as the main worksheet is updated... Currently when I update rows a1 and a10
on main page, a1 and a10 are updated on the linked page.. What I am looking
to do is update rows a1 and a2 on the linked page when a1 and a10 are updated
on main page.

update linked pages
 

I dont think I made myself clear enough... the data on the main page could be
posted on any row... the rows I mentioned were just examples. The data on the
main page might be posted on a1 & 10 and then not till a 25... its got a bank
account program for deposits and expenses.. neither of which would occur
every day. I also have the expenses broken out by catagory so as one catagory
is updated on the main page the linked page is also uipdated. however, if a1
and a10 are updated on main page then a 1 and a 10 are updated on linked
page. I want update a1 then a2 and so on on the linked page.

"Teethless mama" wrote:

On the linked page
In A1: =main!A1
In A2: =main!A10


"jcdipietro" wrote:

I would like to know how to update another worksheet in the very next column
as the main worksheet is updated... Currently when I update rows a1 and a10
on main page, a1 and a10 are updated on the linked page.. What I am looking
to do is update rows a1 and a2 on the linked page when a1 and a10 are updated
on main page.