Sheet name from cell

  • Thread starter Thread starter navin
  • Start date Start date
N

navin

Hi,

Is it possible to assign the sheet a name which is entered in a cell.
I know how to do this with VBA but would like to know if this is
possibile with the help of formula.

Row: A1 has name (Bill). I want that second sheet in the workbook
should have the name entered in row A1.

thanks,
navin
 
It can't be done without VBA.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hlookup with the sheet name is a reference from another cell 2
Sumproduct when data column changes 1
Get Name of Sheet to use in Macro 11
Excel, assign cells in multiple worksheets from one sheet 1
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7
Figuring out a lengthy formula. Probably quite simple... 3
Excel lookup across entire workbook 1
Formula to consolidate 130 sheets into a summary sheet 6

Back
Top