I am trying to create a workbook for inventory purposes. I 10 different worksheets, each one for a specific storage trailer. I list all of the materials that are on that trailer on the work sheet. I am creating a master sheet to display total number of units from all of the trailers, which I have completed, but I am wanting to see if I can get the name of the sheet tab(s) to display so that I can quickly reference which trailer(s) contain the material. Can anyone help with this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Show worksheet names containing a text value
- Thread starter trsearcy
- Start date
My Aswer Is This
Well-known Member
- Joined
- Jul 5, 2014
- Messages
- 19,515
- Office Version
- 2021
- Platform
- Windows
You said:
I am creating a master sheet to display total number of units from all of the trailers, which I have completed,
Are you doing this with a Vba script you already are using?
If so show us your script.
And where should the sheet name be displayed?
And provide exact sheet name of your Master sheet
I am creating a master sheet to display total number of units from all of the trailers, which I have completed,
Are you doing this with a Vba script you already are using?
If so show us your script.
And where should the sheet name be displayed?
And provide exact sheet name of your Master sheet
Upvote
0
Similar threads
- Question
