how do i put drop down box text in to another cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top