Thanks Luke/Jeff, just got a chance to take a look at this.
Luke, thats the problem I'm trying to solve is how to program the spreadsheet so it orders them upon entry.
Jeff, thanks for the link, so far it looks way over my head, but give me a couple days to take a look at it and give it a try.
It is similar but not the same. This question is not as simple as linking information from one sheet to another. The data in sheets A and B pertain to expenses for different months and, for example, the information is entered into rows 2 through 24 in both sheets. So what I'm asking is if...
Ok, so I have 2 spreadsheets each with text and figures and I want to link them both to a third spreadsheet and I want the third spreadsheet to "know" to put the information in sequence. For example there is spreadsheet A,B and C. A and B are linked to C. If I update A and B, then I want C to...
Thank you for your answers but I should've added more detail to my question. Sheet 1 keeps track of the budget and uses a running total so we know how much of the budget is left. On spreadsheet 1 the "Amount" column extends from E3 to E13 and the "Balance" column runs along side it (F3 to F13)...
I'm trying to link a series workbooks that use running totals. The columns in the first spreadsheet are side by side and titled Amount and Balance. Once the figure is entered in the "amount" column it changes the figure in the "balance" column. What I would like to do is create a link that...