G
Guest
I have a spreadsheet from which I need to list all tab names (in a column)
and all column heads (against each tab name).
I need to create this table in a brand new spreadsheet.
I’ve seen posts that use modules to list tab names, but I don’t know how to
use modules.
Once I have my list of tabs, is it possible to use the tab name to reference
to the first cell in the tab? Eg, in cell A1 = TabName, in cell B1,
='[SpreadsheetName.xls]A1'!A1
and all column heads (against each tab name).
I need to create this table in a brand new spreadsheet.
I’ve seen posts that use modules to list tab names, but I don’t know how to
use modules.
Once I have my list of tabs, is it possible to use the tab name to reference
to the first cell in the tab? Eg, in cell A1 = TabName, in cell B1,
='[SpreadsheetName.xls]A1'!A1