Thanks Max. That works brilliantly
"Max" wrote:
"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
---