John asked if there was a way to create a list of all table names in the workbook, along with the underlying table reference. In this post, I’ll demonstrate how this can be accomplished with Power Query and an Excel formula. Objective Before we get into the mechanics, let’s confirm our goal here. We have…
The post List of Workbook Tables and References appeared first on Excel University.
from Blog – Excel University https://ift.tt/37SNOtL
0 Comments