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?
Bookmarks