"Jeff" wrote:
That works very well. Thank you!
Welcome. Pl click the "Yes" button below.

Also if I would like to put the data on a
separate sheet how can I do that?
No problem, if the data is in Sheet2 ..

In Sheet1, with the col/row inputs in B1:B2 as before,
you just use:
=IF(COUNT(B1:B2)<2,"",OFFSET(Sheet2!$A$1,B2-1,B1-1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---