Macro to Group Part #s Together than Identify Those Pulled from Incorrect Bins

[mab1284]

I need a macro to group my part #s together, than look from which bin they were pulled from and identify the ones that were pulled from different bins. See attached file for example.

[LJMetzger]

Hi mab1284,

Try the attached file which (written and tested in Excel 2003):
a. Sorts the data (ascending) by 'Part Number' and then by 'Bin Number'
b. Paints the rows for 'every other' 'Part Number' blue
c. Sets the font to red for each 'Part Number' that has 'Multiple Bins'.

Even if you have little Macro experience the following items can be easily changed to customize the file:

Please Login or Register  to view this content.

I had problems matching your specific BLUE, since I only have access to Excel 2003, and your file may be using color features not available in Excel 2003. In the file is a Macro that will identify the RGB components of the color in the 'Active Cell' to help you customize the colors to your liking.

Lewis

[mab1284]

Thank you. I will try to run the code and see what happens. Again, thank you so very much.

[arlu1201]

Thread posted in CS forum, hence closed.