Hi Alice,

Am Wed, 16 Jan 2013 12:54:00 +0000 schrieb AliceJ:

It's been interesting to me on how to read data selectively from the
other workbook. Rather than pull all data, I just want to read values of
10 cells: the 1st cell has a unique name "ID code", and from this cell
downward to the 10th cell.

open the other workbook too.
In new workbook in first cell:
=OldWorkbookName.xlsl!ID_code
In second cell:
=IF( ROW(A1)<10,OFFSET(OldWorkbookName.xlsm!ID_code,ROW (A1),),"")
and copy down to the 10. row
Close the old workbook and the path will be updatet automatically.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2