.. if (drop down) I3 equals "x" then populate c2:c42:c74 etc. with g3.

Easiest way is to place this simple formula
in each of the cells: c2, c42, c74 etc:
=IF(I3="x",G3,"")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---