LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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.

 
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
HOW DO I LINK PAGES ON EXCEL TO FOLLOW SAME LINKED FORMULA? al Excel Worksheet Functions 0 February 8th 07 08:32 PM
Linked Cells Staying With Cells Once Linked Workbook Update. [email protected] Excel Worksheet Functions 0 June 6th 06 09:32 AM
Linked cells won't update Greg Wetzel Excel Discussion (Misc queries) 3 March 10th 06 08:35 PM
insert text to different pages and update fwburkey New Users to Excel 2 January 27th 06 12:46 PM
creating 1 linked page from 26 pages Klaus A. Excel Discussion (Misc queries) 0 May 11th 05 05:52 PM


All times are GMT +1. The time now is 06:03 AM.

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

About Us

"It's about Microsoft Excel"