macro to automatically insert table in excel

Hello,

I am trying to write a MACRO that I can use at work.

My goal is to have a Macro that would automatically insert a table with headers around the data after it's export into Excel.

The data I export always populates into Excel in the same cells but from different accounts can have much more rows than others -So How do make the code accommodate for that?



So I experimented with some Data and I recorded the Macro of me inserting the table with headers...

The main thing I would Love to know is to how to adjust the Macro to accommodate for different rows of info that might appear.

Also

Once the Macro is in Excel if I export new Data do I just save it to a workbook in order to enable myself to run it for anything new that I would be exporting in or How do I run it once the macro is in excel (Do I find the module and run it?)?

Attached is my excel spreadsheet with the Macro.


Please if there is any confusion, Let me know.

Thank you In advance.