Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Thread Tools Search this Thread
Old 05-02-2012
Join Date: Feb 2012
Posts: 1
Excel 2010 - drop down menus help

Hi all..

I am trying to establish my first co-office business that will allow for new, young entrepreneurs a place to work and start their business. I have tried to work on excel as much as I can but am now stuck with a Formula and would be MUCH indebted with any assistance or advice.


I will be offering 5 styles of rooms (Small to Large) that can house 1-5 people respectively. (Column B23 - Column B33 provides a drop down list of Suite Types 1-5)
I have another column (Columb C23-C33) that provides a drop down list to allow the selection of whether the rooms are Window Facing or Internal rooms. The rent for a Window Facing unit will be 30% more than Internal Units.
I have listed down the Internal Rack Rate of rooms for Suite 1 to 5 in Column E11 to E15

HELP WITH: By inputing (through the drop down menus) the selection of (a) Suite Type (Colm B) and (b) Window/NonWindow (Colm C), I am hoping to be able to automate the Rent in Column E23-E33

I would be MUCH helped with any advice ...

*I use Excel 2010*

Thank you !
Reply With Quote
Old 10-02-2012
Join Date: Jan 2006
Posts: 605
Re: Excel 2010 - drop down menus help

To create the Drop Downlist in Excel 2010, first add the list for the datasource. To create the list for the drop down ,enter the data in a single column cells

B4 ? apple
B5 ? ball
B6 ? cat
B7 ? dog
B8 ? elephant

The list can be added from the Data tab -> Data Validation ribbon. Select the cell / column where the drop down list should be displayed and choose the datasource in the following window. Now the dropdown list should appear.
Reply With Quote

  TechArena Community > Software > Windows Software
Tags: , , ,

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Similar Threads for: "Excel 2010 - drop down menus help"
Thread Thread Starter Forum Replies Last Post
Drop Down Box in Word 2010 jesuse Windows Software 1 24-03-2012 04:48 PM
How to hide drop down arrows in Excel Rao's Windows Software 2 07-01-2012 09:26 PM
Unable to see drop down menus on websites in internet explorer 8 $Daiwik$ Technology & Internet 5 21-02-2011 10:20 AM
Why is my CSS not doing drop down menus? Wajeeha Software Development 5 17-05-2010 11:32 AM

All times are GMT +5.5. The time now is 08:55 PM.