Show worksheet names containing a text value

trsearcy

New Member
Joined
May 3, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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?
 

Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
18,233
Office Version
  1. 2013
Platform
  1. 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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,578
Messages
5,770,949
Members
425,653
Latest member
UNSING

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top