Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Dec 23, 2012, 05:57 PM   #1
tommy060289
macrumors regular
 
Join Date: Jun 2011
Create drop down list with options from cell range

Hey everyone,

I am creating a Diet diary and I intend to use the spreadsheet to create a meal by selecting ingredients from the drop down menu (e.g. if I wanted to check total content of breakfast, I might select some cereals in row 1 and milk in row 2). I intend to use the VLOOKUP function to do most the work but the bit im having trouble finding is making the first cell a drop down list. I know I can do it from pop-up menu in inspector but that means I have to enter all the options in to the list. I want the options in the drop down list to be just everything from the Column A in a table.

How do I do this?

Cheers,

Tom
tommy060289 is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
I Need to Create a Website Quick! Best Options? ((No Tumblr) I Just Bought a Domain)) HappyDude20 Community Discussion 3 Mar 25, 2013 05:03 PM
What be the best way to create an app with a list of editable items fstigre iPhone/iPad Programming 14 Nov 24, 2012 07:52 PM
Create files from list in CSV jasperx Mac Programming 22 Oct 19, 2012 09:27 PM
Looking to create a backup of Aperture. Should I use a vault or drag and drop? Star Nuts MacBook Pro 0 Aug 31, 2012 12:11 PM
iPhone: Why doesn't Safari/Mail give me Page Range print options? Mazda 3s Jailbreaks and iOS Hacks 1 Jul 22, 2012 04:54 PM

Forum Jump

All times are GMT -5. The time now is 03:57 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC