Please don't SHOUT !!

I think what you want is dependent data validation - Debra Dalgleish
shows how he

http://www.contextures.com/xlDataVal02.html

Hope this helps.

Pete

On May 8, 10:15 pm, Tbram wrote:
TRYING TO PUT IT (IF THE MANUFACTURER IS A (FROM A DATA VALIDATION LIST),
THEN THE PRODUCT CAN ONLY BE CHOSEN FROM A LIST FROM COMPANY A'S WORKSHEET -
I'M CONFUSING MYSELF BUT I KNOW YOU GUYS KNOW.

MAIN PAGE
A B
2 MANUFACTURER /COMPANY PRODUCT
3 DATA VALIDATION LIST OF COMPANYS (DROP DOWN MENU CREATED FROM
COMPANY A'S WORKSHEET LIST OF PRODUCTS)
4 COMPANY B ("" FROM
COMPANY B'S LIST OF PRODUCTS)

COMPANY A
PRODUCT A
PRODUCT B
PRODUCT C