Forum Discussion
How I can extract the name of the sheet and pasted it in a cell?
Hi, I would like to know, How I can extract the name of the sheet and pasted it in a cell, with a function? (not using Macros and VBA) Some one can help me with this?
Can we not link the all the formula cells from different sheets to a cell in your sheet1(Index)?. We must write the formula =TEXTAFTER(CELL("filename"),"]",-1) in all the sheets by simply holding the CTRL key and write the formula in the first sheet and all the other sheets will have the formula in the same location as your first sheet.
Thank you for your reply, it help me a lot.
