Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking workbooks
I have come to this excel group on many occasions, and have had most
of my questions answered by searching through the posts. So I thank all who contribute. This problem, though, eludes me and I can't seem to find it in the groups. I use Excel 2003. My problem is this... I have two Workbooks - "Revenue Worksheet" and "2009 Revenue". From Revenue Worksheet I want to link cells B162:S162 (which is a total of a certain amount of columns) to a cell range in 2009 Revenue. Which I can do. The problem is that in Revenue Worksheet rows maybe added (1, 2, 3 rows etc at varying times) before the total row a month or 6 down the line. Once those rows are added 2009 Revenue still links to 162. When infact it is now 170. I have to continually go back to 2009 Revenue to change the linked cells. (And find that I have to do each cell at a time.) My question is, is there anyway to make 2009 Revenue pull from that Total row in Revenue worksheet as it moves to different cells? It seems that this works when it is within the same workbook, but I cannot get it to work in different workbooks. I hope this all makes sense, as sometimes what makes sense to me, doesn't make sense to most other people. If you need clarification please let me know. Thanking all in advance for any thoughts on this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking to other workbooks | Excel Worksheet Functions | |||
Linking workbooks | Excel Discussion (Misc queries) | |||
linking 2 workbooks | New Users to Excel | |||
Linking 2 workbooks | Excel Worksheet Functions | |||
linking two workbooks together | Excel Discussion (Misc queries) |