Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Fill cell with a worksheet name?
2,377 views
Skip to first unread message
S.@discussions.microsoft.com Adri S.
Jan 16, 2008, 11:28:00 AM1/16/08
to
I have a workbook that will be used for employee evaluations. Each sheet is
for a different employee, and the sheet is named for the employee. I would
like the employee name, from the sheet tab, to appear in cell B1 of the
appropriate spreadsheet. For example, if the sheet tab says "Joe Smith" I
would like cell B1 to grab the name of the tab and also say "Joe Smith."
for a different employee, and the sheet is named for the employee. I would
like the employee name, from the sheet tab, to appear in cell B1 of the
appropriate spreadsheet. For example, if the sheet tab says "Joe Smith" I
would like cell B1 to grab the name of the tab and also say "Joe Smith."
I used the formula =CELL("Filename",A1) but it gives me the entire path name
and I only want the sheet tab name. What formula will perform this function?
Thank you!
Marcelo
Jan 16, 2008, 12:00:03 PM1/16/08
to
RIGHT(CELL("filename";A1);LEN(CELL("filename";A1))-FIND("]";CELL("filename";A1);1))
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"Adri S." escreveu:
CLR
Jan 16, 2008, 12:00:03 PM1/16/08
to
=MID(CELL("Filename",A1),FIND("]",CELL("filename",A1),1)+1,99)
Vaya con Dios,
Chuck, CABGx3
Adri S.
Jan 16, 2008, 12:06:02 PM1/16/08
to
Beautiful! It worked. Thank you for your help!
CLR
Jan 16, 2008, 12:12:01 PM1/16/08
to
You're welcome, thanks for the feedback.........
ganes...@gmail.com
Jul 27, 2012, 3:25:55 AM7/27/12
to
On Wednesday, 16 January 2008 21:58:00 UTC+5:30, Adri S. wrote:
> I have a workbook that will be used for employee evaluations. Each sheet is
> for a different employee, and the sheet is named for the employee. I would
> like the employee name, from the sheet tab, to appear in cell B1 of the
> appropriate spreadsheet. For example, if the sheet tab says "Joe Smith" I
> I have a workbook that will be used for employee evaluations. Each sheet is
> for a different employee, and the sheet is named for the employee. I would
> like the employee name, from the sheet tab, to appear in cell B1 of the
> would like cell B1 to grab the name of the tab and also say "Joe Smith."
>
> I used the formula =CELL("Filename",A1) but it gives me the entire path name
> and I only want the sheet tab name. What formula will perform this function?
>
> Thank you!
Hi
>
> Thank you!
I have a workbook consisits of plenty of worksheets. In a mastersheet I have a list of worksheet names in one column and corresponding dropdown list in the next column. Can I get any excel formula or VBA code that will automatically populate/update the worksheet names whenever the user creates/copy new worksheet within the workbook? Any help is appreciated.
Regards,
Ganesh A
0 new messages