If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
I have some unfortunate news for you. Searching the "utterly useless"
help for the keywords '3d range' (w/o the quotes) leads to the topic 'Refer to the same cell or range on multiple sheets,' which contains the section 'Functions that can be used in a 3-D reference'. Neither VLOOKUP nor HLOOKUP is listed in it. That said... Who do you work for? A legacy airline? What do you do that requires a price list with more than 65536*256 entries? If nothing else, maintaining that with any degree of accuracy must be a nightmare. ;-) -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Tushar - now I have the range names and it works for the sum function but I do not seem to be able to reference teh range with V/HLOOKUP which is really why I want the extra spreadhseets in the range (needless to say I have price tables that don't fit on one sheet). Any thoughts as to how to resolve this. Thanks David "David" wrote: I am looking for a very simple piece of code illustrating the format for a "3D" range ie one that spans more than one worksheet. Can anyone help. the MS help function is utterly useless. Thanks |
#22
|
|||
|
|||
Actually I work for a fund management company and we mainatin historical
daily prices on the traded stocks we monitor. The prices are used for back testing as well as generating technical signals for current trades - MACD etc. Excel constrains us to 256 days of history if we stack the stock horizontally or 256 stocks if we stack the stocks in columns. My thought was that one could create and enlarged named range crossing 2-3 sheets allowing me to run price history on the several hundred stocks we cover. From what you are saying this may not be possible. Do you have any ideas? "David" wrote: I am looking for a very simple piece of code illustrating the format for a "3D" range ie one that spans more than one worksheet. Can anyone help. the MS help function is utterly useless. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Problem with graph ranges | No Such Luck | Charts and Charting | 6 | December 3rd, 2004 01:09 PM |
Named Ranges (transfer to a new workbook) | Dennis | General Discussion | 1 | October 25th, 2004 07:57 PM |
Chart Data Ranges | Joyce | Charts and Charting | 2 | October 8th, 2004 09:54 PM |
Import changes named ranges | ICE9 | General Discussion | 3 | August 25th, 2004 01:49 AM |