Naming Worksheets and Footers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Two questions -
How do I set the name of a worksheet to a cell in a list - say, A1 on sheet 1?

How do I set the footer to grab data from cells - say, A2 and B2?
 
1. If the workbook is saved use below formula in A1.

=MID(CELL("filename",$A$1),FIND("]",CELL("Filename",$A$1))+1,255)

2. Needs vba code. Try to record a macro.


Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Free addins Excel Menu-2003 for Excel-2007)
If You Can't Excel with Talent, Triumph with Effort.
 
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

Naming non-contigent cells with vba 5
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
How to hide password? 1
Disable/enable or lock/unlock cells in VBA dependent on other cells values 2
Combine 2 columns in a dynamic range into one 7
How do I insert the name of a named range in a footer in Excel? 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Run two macros for two different sheets 11

Back
Top