Forum home » Delegate support and help forum » Microsoft Excel Training and help » Multi Drop Down Boxes with a final value

Multi Drop Down Boxes with a final value

ResolvedVersion 2010

Wed 15 Jun 2016, 16:42 Delegate Rich said...

Rich has attended:
No courses

Multi Drop Down Boxes with a final value

Help Please

I have created a multi drop down spreadsheet
First drop down is 8 Options (product type) once selected the next column has a further amount of options (products)

Once selected you manually type in the quantity required on a 3rd column and hand to our warehouse to pick

For stock take id like this spreadsheet to work out values from our price list and multiply by quantity picked.

I have over 100 different products

Is this possible???

Please treat me like i'm 5 as sumif, vlookup etc is blowing my mind

thanks in advance

Rich

Thu 16 Jun 2016, 09:47 Trainer Marius said...

RE: Multi Drop Down Boxes with a final value

Hi Rich,

Thanks for your question. It certainly sounds like Vlookup combined with the drop-downs would be the solution. I shall prepare a spreadsheet with a simple example of how it might work. Are you able to give me your email address so that I can send you the Excel file?

Kind regards
Marius Barnard
Excel Trainer

Thu 16 Jun 2016, 10:45 Delegate Rich said...

RE: Multi Drop Down Boxes with a final value

Thanks

How do i send the email private?
my account does have my email address??
or send me yours and i will reply

Rich

Thu 16 Jun 2016, 10:52 Trainer Marius said...

RE: Multi Drop Down Boxes with a final value

Hi Rich,

Unfortunately I don't have access permissions for delegate information or courses attended. Please could you send an email to marius@stl-training.co.uk, then I'll reply with the solution.

Regards
Marius

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips

Multi Drop Down Boxes with a final value

Multi Drop Down Boxes with a final value

RE: Multi Drop Down Boxes with a final value

RE: Multi Drop Down Boxes with a final value

RE: Multi Drop Down Boxes with a final value

Excel articles

Excel tip:

Entering text in Multiple Worksheets