Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell reference in another workbook
I have 12 monthly workbooks with one section that summarises the data for the
month into about 10 sections. So, in the summary I have about 10 rows, with basic formula B100=sum(B2:B10) B101=sum(B11:B20) and so on. I have another workbook for the year that references the cells in the summary My question is, if I have both the workbooks open(current month and year), and I insert a new row, the summary will change to B101=sum(B2:B10) and the reference in the yearly workbook will be updated as well. If the yearly workbook is closed, and I insert a new row into the current month, the refernce will not update in the yearly workbook, it will still try to reference B100 Do both workbooks have to be open? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell reference in another workbook
Yes, unless you're using a named range.
In article , Corben wrote: Do both workbooks have to be open? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell reference in another workbook
Could I use a formula to look at a cell next to it and then return based on
the text inside that cell? ie: if A100 = "Group A", return contents of B100. "JE McGimpsey" wrote: Yes, unless you're using a named range. In article , Corben wrote: Do both workbooks have to be open? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell reference in another workbook
Why not just use named ranges as JE suggests?
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Corben" wrote in message ... Could I use a formula to look at a cell next to it and then return based on the text inside that cell? ie: if A100 = "Group A", return contents of B100. "JE McGimpsey" wrote: Yes, unless you're using a named range. In article , Corben wrote: Do both workbooks have to be open? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel footer reference to cell in workbook | Excel Discussion (Misc queries) | |||
Reference & update destin. cells on 1st machine from source workbook on 2nd machine. | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Bring the cell format along with the cell value from a reference c | Excel Worksheet Functions | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions |