Excel Drop Down Delections

mathetes , sure.

It is an "Equipment Selection" application.  25 criteria that is macro-copied beneath the drop down selection of which equipment you choose, and then it calculates/counts all the items that qualify with those criteria.

So I have 70 pieces of equipment, you pick one, it loads the criteria (copy/paste) and shows how many items fit in the specific chosen equipment.

I have 10 drop downs in 1o different columns that all select from the same data to load the criteria.  Because I am pasting below the drop down in each drop-down column, the paste instruction has the specific address of that column.  So there are 70 instructions for each column in the macro to paste to the specific column, and since there are 10 columns, that makes 700 macro instructions.

I would think there is a way to copy from the equipment data just as I do now, but paste in a relative column of the drop down I am in and NOT have to give the specific column's address.