Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-22-2007, 07:40 PM
Grapejuice Grapejuice is offline
Novice
Drop down box in a cell
 
Join Date: Jun 2006
Location: Toronto Ontario Canada
Posts: 5
Grapejuice
Default Drop down box in a cell

I'm trying to find a way to make a cell into a drop down box with 5 to 8 selections. Depending on what is selected I would like to have 3 to 4 of the cells next to the drop down cell fill in some standard information based on the selections.


Eg. If "Reg Hours" is selected then to the right of it would fill in automaticaly a formula based on Regular hours so that all I have to do is type in the ammount of hours and excel will do the rest.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down box in a cell file -> open -> drop down arrow docsworld Office 1 05-03-2008 08:49 PM
click a cell to go to a worksheet victor Excel 0 10-27-2006 02:57 PM
Drop Down Lists Browett Excel 0 12-19-2005 04:20 PM
Drop down box in a cell Error Copying file or folder - Drag-N-Drop--> Network Shared Kris.Fulgham Outlook 1 10-17-2005 09:02 AM


All times are GMT -7. The time now is 10:22 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft