T
Tony
I want to be able to use data validation (or another method if similar
results) to see mulitple columns when I click on the drop down box, but
only have one column's cell selected.
For example, I would like to click on any one of the drop down boxes on
"Sheet 1" column A and see all three columns (Item, Part Number,
Description) on the worksheet "Source" but only have the part number
entered into the cell when a choice is selected.
Can this be done? I know you can do something like this in Microsoft
Access.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
results) to see mulitple columns when I click on the drop down box, but
only have one column's cell selected.
For example, I would like to click on any one of the drop down boxes on
"Sheet 1" column A and see all three columns (Item, Part Number,
Description) on the worksheet "Source" but only have the part number
entered into the cell when a choice is selected.
Can this be done? I know you can do something like this in Microsoft
Access.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***