Perfect! Thanks.

"Debra Dalgleish" wrote:

Instead of using combo boxes, you could use data validation lists. There
are instructions in Excel's Help, and he

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

t Killion wrote:
I am trying to build a spread sheet that records weekly data. I am using drop
down boxes for the input to standardize the records. I cannot figure out how
to copy the drop down boxes from row 1 to row 2 and have the associated cells
dynamically applied. (i.e if a drop down box is created in cell A1 and by
making a selection the output is put in cell AA1, when I copy the drop down
box to cell B1 I want to have the output placed in cell BB1.

Any Ideas?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html