im trying to create a 'equipment selection' i would like to used drop down
boxes to select equipment from tables, i would then like to take the results
and put them into another 'final' work book to be printed.

can i put rules in cells to look at the cell link and copy in the correct
drop box selection? how is this done?

does that make sence?