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