My problem consists of integrating data from two locations. In worksheet One
I have collected about 500 rows of data over 14 columns. Column C houses
client names and thus acts as a unique identifier. The rest of the columns
consists of address, financial data, etc.... Worksheet Two includes a drop
down list that the manager can look up a particular client (based on
Worksheet One) which then populates other fields for the sole purpose of
sending out a nicely layed out invoice. I would like worksheet one to color
code the row based upon matching client names which can change often in
worksheet two. I do not want to use conditional formatting as this tends to
slow down the application. Any suggestions on VBA?