Hans,

You can use formulas, macros, worksheet events, links.....

Which is best for you depends on more information than you've given.

HTH,
Bernie
MS Excel MVP


"Hans" wrote in message
. nl...
I want to get an address from a workbook "members" to be filled into one or more worksheets of
another workbook. How can I do this without copying and pasting?

Hans