List all Sheets in an Excel Workbook (NO VBA) - Get.Workbook(1)

preview_player
Показать описание
In this video, I demonstrate how to extract the list of all sheets in a workbook without using VBA. The approach uses Get.Workbook, an "old" XLM Macro function. fasten your seatbelts

Link to workbook:
  1. ExcelMoments
  2. Microsoft Excel
  3. REPLACE
  4. Name Manager
  5. SEARCH
Рекомендации по теме
How to Get 0:00:50

How to Get a List of All Worksheet Names Automatically in Excel

How to List 0:03:18

How to List All Sheet Names In An Excel Workbook

List All Sheet 0:07:55

List All Sheet Names In An Excel Workbook With & Without VBA

List all Sheets 0:14:32

List all Sheets in an Excel Workbook (NO VBA) - Get.Workbook(1)

Excel Formula to 0:11:28

Excel Formula to List All Sheet Tab Names and include Hyperlinks

Rename All Sheets 0:07:10

Rename All Sheets From A List... In One Step

How to Get 0:02:54

How to Get a List of All Worksheet Names Automatically in Excel.

Combine Data from 0:06:51

Combine Data from Multiple Sheets in a Single Sheet

How to create 0:01:25

How to create a drop-down list in Google Sheets | 2024

How to create 0:02:05

How to create a list of hyperlinks to all worksheets in an excel workbook

The Easy Way 0:05:19

The Easy Way to Create Sheets from a List of Values in Excel

Use This Trick 0:00:45

Use This Trick to Rename Multiple Excel Worksheets

How To Create 0:02:48

How To Create Multiple Worksheets From A List Of Cell Values

Read All Worksheets 0:04:10

Read All Worksheets of Excel File into List in R (Example) | Import Sheets | xlsx & readxl Packa...

Combine all sheets 0:04:31

Combine all sheets into one in excel | Power Query (the easiest method!)

List All Sheet 0:07:34

List All Sheet Names In Excel Workbook Without VBA|Excel:Create an automated list of worksheet names

Google Sheets: Get 0:07:32

Google Sheets: Get List of all Sheet Names and Reference Cells on other sheets

List All Your 0:29:48

List All Your Sheets Efficiently in Excel (10 Levels)

AWESOME Excel trick 0:07:27

AWESOME Excel trick to combine data from multiple sheets

Get the Sheet 0:03:49

Get the Sheet Name in Excel (Easy formula)

How to copy 0:01:14

How to copy or move all worksheets to a new workbook at a single click

Link Every Worksheet 0:05:21

Link Every Worksheet to a Master Sheet - Excel Organization Tips

How to create 0:02:47

How to create multiple sheet with name in Single click Excel Tips and Tricks

Combine Multiple Worksheets 0:17:23

Combine Multiple Worksheets to One Master Sheet in Google Sheets (Tab Names Included)

Комментарии
Автор

Loved the way you explained the entire formula in steps.

manishagupta
Автор

HI Victor. your videos are like goldmines. Thanks for posting this solution and the introduction of the T function concatenated with the NOW () to make the formula recalculate every time you add or delete a sheet. Regards

jazzista
Автор

Brilliant 👏 This is so useful. You can easily hyperlink the sheets after you've gotten the names of the sheets. Thanks for sharing

nonoobott
Автор

This was exactly what I needed, that you for explaining it so good!

neelamzaidi
Автор

cool tutorial !
how to make the list sheets horizontaly ?

vitarathiel
Автор

Great Video, one question. I want to have an Excel that uses the sheet names in this formula to fetch a value from said the sheet. How do I accomplish this? I usually use =Sheetname!A1 for example. But is there a way to use your formula to fetch the new sheetname and then make Excel get the a value from a designated cell in the sheet with that name?

joakimtharlin
Автор

Hello! Thanks for this! I tried this and I keep getting the #N/A error. I created the Get.Workbook in Name Manager, then go to =SheetNames and straight away gives me this error - I have 365 and I'm not sure if it is just not compatible? Please can you help? :)

biancarodriguez
Автор

I have created it successfully and it works. I got an error #Name? after I refresh on another day with added worksheet. I have to delete all those get.workbook in Name Manager save it and recreate it again to get it work. Any better solution?

mahwilson