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