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