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.
Bookmarks