copying addresses from one workbook to another into several worksheets
 

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

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