Pull down lists

[shaun collier]

Hi all,
I want to make a worksheet with buttons that when clicked produces a pre
made list. However I need to have this in cells next to each other, so I can
use them in a test results sheet I produce for my customers. I currently
type in the data manually and to be honest most of is repeat data. The
buttons need to be pretty when printed. Is excel the right program or is
'access' better, but I am running a Mac with office 2004....any ideas
appreciated
Regards
Shaun

 

[Bob Phillips]

Use Data Validation.

See http://www.contextures.com/xlDataVal01.html

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)