Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Update Cells bases on another workbook.
I looked at all the posting regarding update and could find no solution to my
quest. I have two workbooks open, 1. MastedSum.xls 2. DailySums.xls MasterSum has references to cells in DailySums, when I change cells in DailySums I would like MasterSum to reflect those changes immeditly after entry. I don't even mind having a Macro Button to press to update MasterSum. Any help would be greatfully appreciated. thomas |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Update Cells bases on another workbook.
As far as I know, if you have '=[Book1]Sheet1!$A$1' in Cell A1 of
Sheet1 in Book2 then the changes will be reflected when it changes. Have you definitely got 'Automatic' selected in Tools-Options-Calculation. If it is manual, use F9 to calculate. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Update Cells bases on another workbook.
thom -
below is from another post i did. you could also just use a link formula (e.g., =c:\data\[mybook.xls]sheet1!$a$1) or you couls just put both worksheets in the same workbook cheers - voodooJoe Sub c() srcpath = "C:\SFADB" srcbook = "random.xls" srcsheet = "R1" aydes = Array("c1:c6", "d1:d6", "e1:e6") aysource = Array("$A$5:$A$10", "$b$5:$b$10", "$b$5:$b$10") Set wsdes = Sheet For i = LBound(aydes) To UBound(aydes) With wsdes.Range(aydes(i)) .FormulaArray = "='" & srcpath & "\[" & srcbook & "]" & srcsheet & "'!" & aysource(i) .Copy .PasteSpecial xlPasteValues End With Next i Application.CutCopyMode = False Set wsdes = Nothing End Sub edit to fit - voodooJoe "thom hoyle" wrote in message ... I looked at all the posting regarding update and could find no solution to my quest. I have two workbooks open, 1. MastedSum.xls 2. DailySums.xls MasterSum has references to cells in DailySums, when I change cells in DailySums I would like MasterSum to reflect those changes immeditly after entry. I don't even mind having a Macro Button to press to update MasterSum. Any help would be greatfully appreciated. thomas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I email my colleagues automatically when i update a workbook? | Excel Discussion (Misc queries) | |||
I want to combine 2 workbook data bases and remove duplicates | Excel Discussion (Misc queries) | |||
Need formula that will sum cells in a column bases on criteria in other cells. | Excel Worksheet Functions | |||
Automatically update cells | Excel Discussion (Misc queries) | |||
Hide prompt to automatically update links on workbook opening | Excel Programming |