Domenic's is cleverer, mine is more understandable <vbg

--
HTH

Bob Phillips

"Sam via OfficeKB.com" wrote in message
...

Hi Bob,

Thank you for very much for alternative solution - also works great!

=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)

Cheers
Sam


Bob Phillips wrote:
Do you just mean

=INDEX(Sheet1!$B$1:$E$1,,ROW()-7)

Hi All,

[quoted text clipped - 16 lines]
Thanks
Sam


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1