New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

IMAGE DEPENDING ON DROPDOWN

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

IMAGE DEPENDING ON DROPDOWN

Postby sknair » Tue Jun 14, 2016 2:46 am

Hai.
I am working on a file and would like to create a file for creating the quotation & invoice.
I have around 6000 line items and i would like to prepare the file in such way.

IN the quotation format i would like to place a drop down As Brand Name, so upon selection of Brand name the item from a particular brand must come in the second Column Category will show the items from that Particular brand only
And on selection of Category , i should get the Items categorized in that Head ( as below, If i select brand AAAA, in 2nd drop down it should show only Table & Chair And in second Drop down if i select "Chair" 3rd drop down i should get only ORA, EVA EDEn only.)

And if i Select EVA chair, The Image Column should appear the picture of the chair.

Eg:

Brand [b] Category Items [/b]

AAAA Tables, Table of 1600 length,
Table of 1800 Length,
Chairs ORA chair
Eva chair
BBBB Sofa, EDEN Sofa
GEMI Sofa
Cabinets, UC Cab 1800
UC Cab 200
Chairs LUCY Chair
VIRA Chair
CCCC Table JAZZ Table 1600
Chair
Sofa

Can any one help me to solve the issue.

sknair
  • 0

sknair
Rookie
 
Posts: 1
Joined: Jun 13, 2016
Reputation: 0
Excel Version: 2010

Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 49 guests