Copy title in cells

[Dookie]

If anyone could help me please

I would like the name of my excelbook or the name of the worksheet to be copied in a specific cell into the same Excelbook , in order to avoid rewriting whenever i open a new workbook.(new file)
Thank u in advance for your support....

 

[Dookie]

Sorry to annoy you friend, but it seems that i didn't get something of it.
The name of the book is "May". I want the title of the book to enter in one specific cell in a worksheet in that book, ok?(so whenever i make a copy of this workbook with a different name, the data in my cell will change with the new name).


What i've done, is this:

I open my book and open a new worksheet, writing down:
A1: May
A2: Data

Then i go to the other work sheet that i want my information to be entered, and write down in two different cells


The formula, you mean this right??
First cell
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1))+1,FIND("]",CELL("filename",A1))-FIND("[",CELL("filename",A1))-1)

Second Cell
=RIGHT(CELL("filename",A1),LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1)))


What am i doing wrong???

And again sorry to disturb you with it....

 

[VoG]

I open my book and open a new worksheet, writing down:
A1: May
A2: Data

You do not need to do that. The formulas return the values.

Example file http://www.box.net/shared/kd2ad66tu2

Try saving with a different filename then press F9 - see what happens in A1.

Change the sheet name - see the change in A2.

 

[Dookie]

I'm at workand not able to see it....
I'll check it out, and i'll return..
I'll inform you later, ok?

Thank u my friend. thank u very much