Forum Discussion

JACK74's avatar
JACK74
Copper Contributor
Apr 24, 2020
Solved

DROPDOWN MENU

I try to create part number/description generator. So far I am able to create part numbers, but on the same time I would like to generate description using cells on other sheets. Please check attache...
Formulas and Functions
  • JACK74's avatar
    JACK74
    Apr 25, 2020

    Riny_van_Eekelen  thank you very much. This is what I was looking for :-). 

    One more thing, do you think it is possible to deactivate cell for point diameter when other than pencil is chosen from dropdown menu? Or, if is not possible to deactivate, can popup N/A in cell (for point diameter) when pen or marker is selected? Thank you again for your help.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Apr 25, 2020

JACK74 Offering you three solutions. Please refer to the attached file. The one in F6 might not work if you are not on a later version of Excel.

JACK74's avatar
JACK74
Copper Contributor
Apr 25, 2020

Riny_van_Eekelen  thank you very much. This is what I was looking for :-). 

One more thing, do you think it is possible to deactivate cell for point diameter when other than pencil is chosen from dropdown menu? Or, if is not possible to deactivate, can popup N/A in cell (for point diameter) when pen or marker is selected? Thank you again for your help.

    • JACK74's avatar
      JACK74
      Copper Contributor
      Apr 27, 2020

      Riny_van_Eekelen thank you for your help. 🙂  For me this is black magic. LOL

Resources