Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Populate & Name Recognition
Can Excel 2003 recognize a name in a call in one workbook and then auto
populate the cells from the original worksheet by name recognition? -- Leigh Anne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Populate & Name Recognition
Not quite automatic...
But you can use a table on that second sheet and a formula... Create a new table (A1:Bx, say) on a different sheet. Give the first column (A1:Ax) a nice name. Use Data|Validation to create a dropdown list with those options as the choice. Use a formula in the adjacent cell to retrieve the value in the adjacent column in the table. =if(a1="","",vlookup(a1,sheet2!a1:bx,2,false)) Debra Dalgleish has some notes about naming the range: http://contextures.com/xlDataVal01.html#Name And for using =vlookup(): http://www.contextures.com/xlFunctions02.html (for =vlookup()) and http://contextures.com/xlFunctions02.html#Trouble Leigh Anne wrote: Can Excel 2003 recognize a name in a call in one workbook and then auto populate the cells from the original worksheet by name recognition? -- Leigh Anne -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Populating & Name Recognition between Worksheets | Excel Worksheet Functions | |||
Auto populate | Excel Worksheet Functions | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
auto populate | Excel Discussion (Misc queries) | |||
Dropdown menu auto recognition? | Excel Discussion (Misc queries) |