Header as cell value

  • Thread starter Thread starter michaelberrier
  • Start date Start date
M

michaelberrier

I've seen 1000 posts on how to base a header on a cell value. I need
to do the opposite. That is to say, if the sheet name is "Dogs", I
need to put that value in a particular cell on a separate sheet. This
can be done with vba or indwelling formula.

Thanks to all.
 
The workbook needs to be saved first

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)


will return the sheet name of the sheet that holds the formula

it can be put in any cell (even A1), the cell reference is needed that's
all, it can be any cell reference
 
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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel VBA 1
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Need help with macro to copy, paste, and clear cell values 8
if statement with vlookup 1
Excel VBA to move cells to sheet2 based on selection in sheet1 0
Using text in a cell in a formula 2
Dynamic Header 4

Back
Top