How to convert data on multiple sheets into the Excel Table format?

[vanbasten007]

Hi guys,

I have a workbook that contains something like 50 worksheets and they all contain data with the same columns, for example column A is Project, column B is Project Name, etc. I need to convert data in each worksheet into an Excel Table. There has to be an easier way than manually converting each worksheet into a Table. However, when I group all of the sheets, the option to Insert a Table is not available even though the data starts in the same row and contains the same number of active columns in each worksheet. Is there an easier waty to insert a table in all of the worksheet simultaneously?

[Xx7]

This requires VBA and the logic will be:

1) Loop through each worksheet
2) Select range (which will likely be similar for each sheet)
3) Convert to table

[Xx7]

See if this does the job for you!