Format table with variable number of entries

[ccarvalho]

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

[oeldere]

I can't open your PNG file.

But why not make a range that always covered your data (e.g. 100 rows).

[oeldere]

Please read the forumrules, especialy the ones about crossposting.

http://www.mrexcel.com/forum/excel-q...r-entries.html

[ccarvalho]

oeldere, I don't know why the image isn't working. The file attachement wasn't working either. Maybe there's a problem with the upload feature.
Anyway, how do I do what you suggest in a macro? I'm new at this, so I'm not sure how to implement that idea.

Thanks
ccarvalho

PS. Sorry about the crossposting. I added the link to the other forum, in the original post.

[oeldere]

I've created a macro but the problem is that the macro only works for files with the same number of entries.

then show the forummembers the code.

please post the code in tags # (according to the forumrules).