I have an Excel Workbook downloaded from an Internet site. It has only one sheet with 50 suppliers listed on it. Each supplier is shown with a header row and the next row shows the shipping parameters in 10 columns. I need a VBA code for Excel 10 to loop through the sheet and create tables and rename the table for each shipper. I can record a macro that works fine, but the shippers change over time then the macro will not work. When recording the macro I click on the first column in the row showing the parameters (Shipper ID) and Excel knows the range for the table. I am new to VBA and trying to learn, any help is appreciated.