Thanks for the replies. Where to start.....i'm collecting the daily shortsell list from the ASX (because they wont supply historical information without asking a fee), to see the impact of shorting on SP.
So each day i save a worksheet in the workbook that contains all the shortsell information for that day. The first worksheet in my workbook is my analysis worksheet. In it i vlookup a specific company for each day and transfer that to the analysis page where i then graph it. So that i don't have to keep copy/paste and then hasve to overwrite the worksheet name in the VLOOKUP call, i thought i could name each worksheet say a consecutive number and then increment the number in vlookup.
{{{{Grrr when is HC admin going to get it's act together and allow direct paste of screen shots}}}
So i set say cell B1=45; B2=46; B3=47 etc [45,46,47 being the worksheet names], then I try to reference them in vlookup ie =VLOOKUP(G17,'B1'!$A$9:$I$400,6,FALSE),but it doesn't work because vlookup doesn't allow the worksheet call to be a variable. So the question is how can i insert a varible worksheet reference into vlookup.
