Microsoft Excel Tip #4

//Microsoft Excel Tip #4

Tip #4

In order to generate a list of worksheet names:

Open the workbook you would like a list of worksheet names for.

  1. Insert a new worksheet to hold the list of sheet names or navigate to the worksheet you want them to be listed on.
  2. Chose Formulas | Define Name to display the New Name dialog box.
  3. Type “WorksheetList” in the Name field.
  4. Enter the following formula in the Refers To field:

=REPLACE(GET.WORKBOOK(1),1,FIND(“]”,GET.WORKBOOK(1)),””)

  1. Click OK to close the New Name dialog box.
  2. To see the worksheet names list, enter the following formula in cell A1 (or wherever you want to see the list appear) and then copy down the column.

=INDEX(WorksheetList,ROW())

 

If you would like to learn more about this or any Microsoft Dynamics product, please contact Complete Software by calling 410-740-1090 or by emailing support@completesoftware.net!

Based out of Columbia, Maryland, Complete Software Solutions (CSS) is proud to be a Microsoft Partner and Value Added Reseller (VAR) for Microsoft Dynamics GP and Microsoft Dynamics SL as well as a unique software developer providing solutions for businesses and non-profit organizations throughout the country. We offer a variety of services including Microsoft Dynamics consulting, system evaluation, business process analysis, system design, customizations, Enterprise Resource Planning (ERP) implementations and system upgrades.

2014-06-09T14:02:29-04:00