As part of a large food costing and recipe book, I need to pull data from one sheet based upon the color of a cell on the other. On the main data sheet I have multiple tables from various suppliers, on the second sheet I have organized some of the data based upon the type of ingredient, rather than the supplier. I have color coordinated the ingredients based upon supplier, and want to use that color to tell a function which table to look up a price in. I think this should be simple, but I'm over my head..
More simply put:
I'm trying to compare a referenced cell to another from a different table based upon its color, then return the value (text) of the second cell. I think this should be simple with VBA, but I'm over my head.