matt459,

Without getting into the weeds..

if in cell A1 of Sheet1 you have your drop down (data-validation-list), you
could write in Sheet2 cell A1: =Sheet1!A1

That's a start, you might also want to try looking at Debra Dalgleish's
website too. http://www.contextures.com/tiptech.html

HTH

BigPig

"matt459" wrote:

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?