Formula for Tab Content

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

Is there a formula I can use for a cell that will populate a cell with the
content of a sheet tab?
Thank you, Karen
 
Karen,

Put this in a cell. The workbook must be saved for it to work

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

Mike
 

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

Back
Top