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