In one workbook I have a number of worksheets that I wish to summarise.From the summary sheet is possible for excel to supply the worksheet name in a cell ?If so how ? I have tried '=sheetname!' but it does not work.
except that you haven't defined the cell to be linked after the exclamation mark
"is possible for excel to supply the worksheet name" - sorry, I don't understand how Excel is supposed to do this.If you mean can you (not Excel) put the sheet reference in a cell, then use a formula to act on that reference, then I don't think it is possible but I stand to be corrected.
you write the name of the sheet into a cell, and link to that.Say =sheet-name!A1
Have you tried that? I cannot get that (or anything similar that I have tried) to work. But I'm always willing to learn.
Sorry, just to clarify=Sheet1!A1or even='[My silly workbook name]My silly sheet'!A1will work. But what HRH1 is asking (I think) is can you put '[My silly workbook name]My silly sheet' in a cell and use it. I believe that the answer to that is "no" but I may well be wrong.
you would be trying to load the whole sheet into the single cell!I think! Massive doubt and an attack of insecurity but maybe.
No, no, no!That's not what I meant. Say '[My silly workbook name]My silly sheet'is in A1in B1 can you put=A1!D12for example. i.e. a single cell.I don't think you can do this via a cell reference, but.....
The ! identifies the sheet you are referring to.
just a frequent user and I limit myself to fairly simple sheets as I am the only person to see them.
Yes I know what the ! does. I know exactly how to reference a cell on any worksheet in any file on any drive. As I understand it, this is not the problem.
This thread is now locked and can not be replied to.
Best phone camera 2017
Stunning new film posters by Hattie Stewart, Joe Cruz & more
iPad Pro 10.5in (2017) review
28 astuces pour profiter au mieux de votre iPhone
© Copyright 2017 IDG UK. All Rights Reserved.