Format table with variable number of entries

also in http://www.mrexcel.com/forum/excel-q...ml#post4522474


Hi everyone,

I'm trying to get a file formatted automatically. This file is extracted from another program every week or so.
In the image (couldn't upload a xlm file for some reason), you can see an example of what I want to achieve. At the top, you see how the data is initially formated, and below how I want it to be.
I've created a macro but the problem is that the macro only works for files with the same number of entries. This table as a variable number of entries: 1 week it has 10 rows, the other 15, the next 8...you get the idea
How can I format the file for a variable number of entries?
vba.png

Thank you,
ccarvalho