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

M

matt459

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?
 
B

BigPig

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Paragraph numbering in Word 1
Word VBA - Auto Populate Text on Dependent Drop Down Exit 1
drop box/data validation help 0
Drop Down Boxes 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top