jmhassetmanagement
New Member
- Joined
- Aug 10, 2011
- Messages
- 2
Hi all,
I have a complex workbook which contains a column of data fed into excel live from an online source. The data is in text format, and basically comprisies a list of people's names. The list is never longer than 25 names, and is fed into "sheet1" cells A1:A25. Where there is no name on the list, for whatever reason, the value in the cells is given as 0 instead.
Now I assumed that it would be fairly straightforward to export this list of names into another sheet, so that I can perform certain conditional tests, and indeed it has been easy up until now, as I have succesfully built a template called "template1", which sources the names directly from "sheet1" (which is the sheet that populates the list of names from the onlyine source directly) (n.b. I am not the original author of "sheet1", as it is well beyond my current competency level).
At present the cells A1:A25 in template1 derive their contents from cells A1:A25 in sheet1. All values are present and correct, and auto-update as you would expect that they would, from the linked online source (which refreshes every couple of seconds). The problem I have is that for some bizarre reason it seems only possible to export the live data to a single cell once. If i write the code ='sheet1'!A1, into cell A1 on my sheet template1, then it works fine. But if I make any alteration whatsoever to that, then it doens't. If I decide I want to change the contents of cell A1 in template1 from ='sheet1'!A1, to ='sheet1'!A2, excel will display ='sheet1'!A2 (as written) in my desired cell, which is obviously not what I want. If i go to cell b1 (which has never previously contained a formula) and ask the same command of it, i.e. ='sheet1'!A2, it will oblige, at least in the first instance. But if I decide I want ='sheet1'!A3, it will display ='sheet1'!A3, instead of JOE BLOGGS as it should.
I had hoped to build my sheet template1, and make 4 copies of it in my workbook, namely template2, 3, 4, 5, and in each instance link them to the data contained in A1:A25 in sheet2, 3, 4 & 5 respectively (which also take their queue from an online feed). However when I make a copy of template1, excel still refuses to allow me to change the formula in A1:A25; from for example ='sheet1'!A1 to ='sheet2'!A1.
Again if I select a random unused cell in template2 and command it to display the value in ='sheet2'!A1 it works fine, but If I attempt to overwrite the formula ='sheet2'!A1, with ='sheet2'!A2, it displays ='sheet2'!A2 in my cell.... which is obviously not the name of a person!!!
I would be immensely grateful to the community for any guidance that they might be able to provide me with!
I have a complex workbook which contains a column of data fed into excel live from an online source. The data is in text format, and basically comprisies a list of people's names. The list is never longer than 25 names, and is fed into "sheet1" cells A1:A25. Where there is no name on the list, for whatever reason, the value in the cells is given as 0 instead.
Now I assumed that it would be fairly straightforward to export this list of names into another sheet, so that I can perform certain conditional tests, and indeed it has been easy up until now, as I have succesfully built a template called "template1", which sources the names directly from "sheet1" (which is the sheet that populates the list of names from the onlyine source directly) (n.b. I am not the original author of "sheet1", as it is well beyond my current competency level).
At present the cells A1:A25 in template1 derive their contents from cells A1:A25 in sheet1. All values are present and correct, and auto-update as you would expect that they would, from the linked online source (which refreshes every couple of seconds). The problem I have is that for some bizarre reason it seems only possible to export the live data to a single cell once. If i write the code ='sheet1'!A1, into cell A1 on my sheet template1, then it works fine. But if I make any alteration whatsoever to that, then it doens't. If I decide I want to change the contents of cell A1 in template1 from ='sheet1'!A1, to ='sheet1'!A2, excel will display ='sheet1'!A2 (as written) in my desired cell, which is obviously not what I want. If i go to cell b1 (which has never previously contained a formula) and ask the same command of it, i.e. ='sheet1'!A2, it will oblige, at least in the first instance. But if I decide I want ='sheet1'!A3, it will display ='sheet1'!A3, instead of JOE BLOGGS as it should.
I had hoped to build my sheet template1, and make 4 copies of it in my workbook, namely template2, 3, 4, 5, and in each instance link them to the data contained in A1:A25 in sheet2, 3, 4 & 5 respectively (which also take their queue from an online feed). However when I make a copy of template1, excel still refuses to allow me to change the formula in A1:A25; from for example ='sheet1'!A1 to ='sheet2'!A1.
Again if I select a random unused cell in template2 and command it to display the value in ='sheet2'!A1 it works fine, but If I attempt to overwrite the formula ='sheet2'!A1, with ='sheet2'!A2, it displays ='sheet2'!A2 in my cell.... which is obviously not the name of a person!!!
I would be immensely grateful to the community for any guidance that they might be able to provide me with!
Last edited:
