Help required to clean up an excel using macros

[itproguys]

Hi All,
I have a s/w from which I export some data into an excel file. The exported excel file is very RAW and I needed help to clean it and beutify it so that it is presentable. Of the things I wanted to automate via macros are-

1. Insert a new row on top for creating column titles so that viewers know what data that column contains
2. In the same top row I wanted to merge a few cols
3. Fill color in the different rows to logically separate the data
4. Find and remove certain data that has been been added by default (like 0-Jan-00 for all dates that were imported as NULL). I want t blank these out.

Any help and pointers will be highly appreciated

 

[texasalynn]

turn on the macro recorder to walk through your steps. After you record your macro you can post back with the code and we can help you clean it up to make it generic for repeated use.

 

[itproguys]

turn on the macro recorder to walk through your steps. After you record your macro you can post back with the code and we can help you clean it up to make it generic for repeated use.

I will try to do it later in the day...In the meantime if anyone has code snippets on how to insert rows, set title values, fill in color, change font color, search and replace certain values and can share it, that will be highly appreciated. I could then start modifying the code.