Copy drop down boxes and associate to cells dynamically in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down with dynamic named range offsheet source list 14
Dependent drop down dynamic range formula, off sheet. 7
Drop down box issue 2
Formatted cell column in drop down list 1
customize drop-down box 1
How do I create a drop down box within a drop down box? 1
Odd Drop Down Box Behavior 4
data validation fonts differ in drop down box 1

Back
Top