I'm sorry...I didn't explain clear enough. I need a function like the
vlookup function to return information from the selected line of a list. So
that in Workbook1, Sheet1 I can type Smith in cell A1 and if in a list in
Workbook2 on Smith's sheet, account 54321 is selected it will return that
account number into cell A2 in Workbook1, Sheet1. Does that make sense??
Can this be done??

"Otto Moehrbach" wrote:

If you want the Data Validation selection to appear in the same cell of the
same other workbook every time, then all you need is a formula in that cell
of the other workbook.
However, if what you want is to keep a log of the items selected, then
you will need VBA.
Post back and clarify what you want. If a log is what you want, include
the name of the other workbook and the name of the sheet in that workbook as
well as a column and a starting row number. HTH Otto
"liseladele" wrote in message
...
This is hard to explain...but I have a drop down list in a worksheet.
Whatever name is chosen in the drop down list I need to show up in a
different sheet in a different work book. Can this be done? Thanks!