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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

matt459 - 05 Apr 2007 17:30 GMT

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?

Reply to this Message

BigPig - 05 Apr 2007 18:04 GMT

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

> 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
[quoted text clipped - 4 lines]
>
> does that make sence?

Reply to this Message

Rate this thread: