I need Macros help!!!

[copasln]

I have to run a report weekly that displays warehouse inventory going out. I have to ensure everything is coded correctly. This report contains 500-1000 rows and can take a significant amount of time to review. I want to run a macro that will automatically color code a group and product number but not change the rest of the data from my report.

Can I run the report, save it, then Record Macro coloring what I want colored? Then next week, run the report, open recorded macro file, run macro to color new report??? Or at least thats what I envision.

Random example of the report (below).

What I'd like the report to look like after I run a Macro or something (below).

Any macro help or whatever would be greatly appreciated.
THANK YOU!!!!!!!!!!

 

[Michael M]

How many groups will there be ??

 

[copasln]

How many groups will there be ??

There will be 8 or 9 groups. Approximately 750 different product numbers that fall into those 8 or 9 groups. Someone manually enters the group name and the number and sometimes they enter the wrong group for that product number.

 

[Michael M]

Can you post the samle again using the XL2BB addin. It makes it easier to work with...See my tag for the download
You could also sort them in Group order to make things a bit easier to review

 

[copasln]

I don't see the option for the add in XL2BB on my computer. Sorry. I appreciate you trying to help.

 

[Michael M]

The download is in my signature at the bottom of the post

 

[copasln]

 

[Michael M]

Unprotect the sheet first ?

 

[copasln]

my sheet is not protected

Unprotect the sheet first ?

 

[Michael M]

So is the file, read only.
You will need to enable editing
Have a look on the Review Tab and see if the workbook is protected.