B2: is a drop down list of 40 Adlet ID Numbers, C2: is and input box of the
number adlets played based on the adlet ID selected in the drop down box, D2:
is and input box of the number of K2P's based on the adlet ID selected in
the drop down box, D2: is an input box of keythrough ratios based on the
adlet ID selected in the drop down box. Note all of the input boxes are
static numbers that require no calculation. now that this is in put this
information needs to be sent to the analysis work sheet w2: cell b2: needs to
have have the input information added to the previous number updated in this
cell from previous inputs again this is based on the adlet ID selected in the
drop down box each time. Now I need this info to up date each adlet ID on the
second work sheet based on the input information from each drop down
selection.

I hope this makes sense.