Report Formatting using VBA

[Kdoble]

I have a group of reports generated by a 3rd Party Real Estate Management Company's software. The software allows you to convert to Excel. I use the rent rolls to build a price matrix with Pivot Tables. The issue is that the converted Excel Reports do not come in Table Format. I have to spend 15-30 minutes with each report converting to table format. I am looking for examples of how other users have solved problems like this using VBA? I would like to have one VBA program to automate these issues - instead of a different Macro for each property report?


Thanks for any sugguestions

 

[Hui]

Kdoble


Firstly, Welcome to the Chandoo.org Forums


If the sheets come in, in a similar format each time, it will be possible to setup a macro which will select the data and convert it to tables


Even if you have various macros for each property/report they can all be linked together


Without more details try recording the steps to do it manually as a macro.

that at least will give you a template for what you want to achieve.

 

[Kdoble]

Thanks, this is a great website. I have a macro for each report created, it's not the ideal solution because the data being selected keeps changing. I was looking for examples on how other people had handled the issue with reports being exported into excel that have merged columns, spaces, rows, etc. I got the macros to work. I am looking to use WinBatch to automate the entire process of creating these reports.


Thanks again for your help