Hi Hui
Thank you for all your help. I am an extreme novice at excel, but this does not seem to work either or I am using it wrong. Is it possible that I can e-mail you the workbook, that you can see what I am referring to?
Hui
I understand what you are saying. and i have tried every way I know of to get arround this problem.
What i am trying to achieve is. On Sheet2 i have entered a lot of data. it is in table form each with a unique name in top left corner. meaning the name for each data set is in colum A...
Hi Hui
Thank you that works. It does not acheave what i am looking for. If i type =Sheet2!B3 into C1, then i can drag the bottom right corner of cell C1 to auto fill as many cells as I want. Thus giving me the contents of the cells next to B3 on Sheet2. is this possible?
Hi All
Can someone please help with the following problem that I have got? I want to combine text and numbers from different cells to create a formula, but the result just comes out as the combination and not the desired result. In cell A1 I insert = and in cell A2 I insert Sheet2! And in A3 I...