"SueG" wrote:
.. That works great in the same workbook but I'm not sure what I
have to add to the start of the formula so that the data comes from a
different workbook

Provided the source book (eg: book4.xls) is open at the same time*,
you could use something like this in the other book,
and copy down as befo
=INDIRECT("'[Book4]Sheet"&ROW(A1)&"'!A3")

*required for INDIRECT to work
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---