Hi Alice,

Am Wed, 16 Jan 2013 15:59:45 +0100 schrieb Claus Busch:

=IF( ROW(A1)<10,OFFSET(OldWorkbookName.xlsm!ID_code,ROW (A1),),"")

you better work with cell references. With OFFSET or INDIRECT you have
to open the old Workbook to get the formula to work.
if ID_code is in A1
In your first cell:
=OldWorkbookName.xlsx!A1
and copy down 10 cells


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