The bare bones VBA code A simple list of sheet names is easy to generate using VBA thanks to the Worksheets collection. Listing A shows a simple For Each loop that cycles through this collection.

If you have a list of items in a text file and you want to import data from a text file into Microsoft Excel, you can do that without writing them manually.

I have a bunch of DVDs, each filled with dozens of files. I want to create a list of the contents of these discs and put it into a spreadsheet. I want to list the file name, type and size. So far ...

If you need a complete list of Microsoft Excel sheet names, Microsoft Excel Power Query is fast and generates a dynamic list.

You can reverse the row or column order of a list in Excel by creating reference list, a Macro, and using INDEX function. We have explained all these methods.

You can use Excel, Microsoft's spreadsheet program, to store, organize, and analyze data in a number of ways.