| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i put drop down box text in to another cell?
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do i put drop down box text in to another cell?
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pick from 'drop down list' OR enter text in cell | Excel Worksheet Functions | |||
| how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
| add text to cell by clicking a choice in drop down list | New Users to Excel | |||
| how do I drag & drop cell text only | New Users to Excel | |||
| Combining numerical and drop-down text in a single cell | Excel Discussion (Misc queries) | |||
Linear Mode
