Hello, Little Tables?
So, where did tblSpecialty and tblType end up? There should be two new spreadsheets. They may be Sheet2 or Sheet3.
The imported data is formatted as a Table. Each Column has a Filter.
4.
Do This: Rename Two Sheet Tabs
Double-click the Tab for the Specialty Table.
Rename the sheet: Specialty.
Double-click the Tab for the Type Table.
Rename the sheet: Type.
Everybody remember where we parked.
Keep
going...
Look at the Table Properties: The Specialty Table was named Table_tblSpecialty when it was imported. The Type Table was named Table_tblType.