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

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

sorry about hte caps.
I'm trying to say in Column F that if Column E says Company 1 - then use
dropdown menu in F from that Company 1s worksheet

"Pete_UK" wrote:

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