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?

Do you have a list of the company names to use as a "search" type
situation? If so, a column can be made with the color code number in
it next to the company name. Then a basic search function would link
each name on the first sheet back to the color coding on the 2nd sheet.
I can write the code if you have some more info to share as far as what
your needing, number of names, etc


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=513852

My initial thought was for the entire row to turn yellow if the condition is
meet. Specifically if I go to Worksheet Two and at cell C4 highlight the
drop down menu and choose, for instance, ABC Company, then the VBA would
recognize this choice, go to Worksheet One and highlight row 4 because this
is what row ABC Company's data is located (the name specifically in column
C).
This would change each time the user pulls down a different company name in
the dropdown menu in Worksheet Two. Is this doable?

"dok112" wrote:


Do you have a list of the company names to use as a "search" type
situation? If so, a column can be made with the color code number in
it next to the company name. Then a basic search function would link
each name on the first sheet back to the color coding on the 2nd sheet.
I can write the code if you have some more info to share as far as what
your needing, number of names, etc


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=513852

Yes it is. How do you have the drop down coded on the 2nd sheet? Is it
a in-line drop down or a combobox from vba?


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=513852

I created this through the Data Validation menu. I guess it is an in-line
drop down as I did not write in VBA.

"dok112" wrote:


Yes it is. How do you have the drop down coded on the 2nd sheet? Is it
a in-line drop down or a combobox from vba?


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=513852

how many companies are there in the drop down?


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=513852