I've figured out a few things on what I need to do but I'm stuck on a few things. Each week I get a database of cars that with the data in columns such as, make, model, miles, price etc. I use to manually re-arrange the data and turn it into a booklet and print them out. I'm figuring out that much of what I do manually I can write vba code to make excel do it for me. On one worksheet I dump all the data. on a seperate worksheet I've written code to extract from the first worksheet information I need, combine to columns into one and delete duplicates in a certain column. On a third worksheet it pulls the data from the 2nd worksheet. the third workseet is laid out the way I want it to look when I print.

My question is this. On the final worksheet, I have headings for the make of car in column A. below that in the same column are subheading for the model of car. Each week the data will be in a different row depending on the amount of cars in the database. How can I make excel know which row has a heading that is either (audi,acura, bmw, chevrolet etc etc) and color that cell with black, change the heading font to white and make the font "bold".?

does that make sense?