validation

gumby · Apr 6th, 2002, 07:06 PM

I have data in cell a20 -a60 I'm using data/validation/list. I want to put every 6th or 7th cell(a26,33,40,47,53) in drop down list (without having to type the contents of the cells.

Yogi Anand · Apr 6th, 2002, 08:48 PM

Hi gumby:
I would do it this way:
1. Highlite A20:A60 ... DATA|VALIDATION|Settings|Allow|List
2. Create source list, say starting in cell D24 ... =A26, in cell D25 ... =A33, in cell D26 ... A40, in cell D27 ... =A47, in cell D28 ... =A53
3. and the necessary information related to Input_message, and Error Alert

There may be other ways of doing it -- but this way should do it.

Please post back if it works for you ... otherwise explain a little further ... and let us take it from there!

Apr 6th, 2002, 08:48 PM	#2
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	Hi gumby: I would do it this way: 1. Highlite A20:A60 ... DATA\|VALIDATION\|Settings\|Allow\|List 2. Create source list, say starting in cell D24 ... =A26, in cell D25 ... =A33, in cell D26 ... A40, in cell D27 ... =A47, in cell D28 ... =A53 3. and the necessary information related to Input_message, and Error Alert There may be other ways of doing it -- but this way should do it. Please post back if it works for you ... otherwise explain a little further ... and let us take it from there! __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 6th, 2002, 07:06 PM	#1
gumby New Member Join Date: Apr 2002 Posts: 13	I have data in cell a20 -a60 I'm using data/validation/list. I want to put every 6th or 7th cell(a26,33,40,47,53) in drop down list (without having to type the contents of the cells.