Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HOW DO I LINK PAGES ON EXCEL TO FOLLOW SAME LINKED FORMULA? | Excel Worksheet Functions | |||
Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
Linked cells won't update | Excel Discussion (Misc queries) | |||
insert text to different pages and update | New Users to Excel | |||
creating 1 linked page from 26 pages | Excel Discussion (Misc queries) |