Index Row and return data in a Single Column:No return

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

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

--
HTH

Bob Phillips

"Sam via OfficeKB.com" <forum@OfficeKB.com> wrote in message
news:519C5C034A568@OfficeKB.com...
>
> 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

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

--
HTH

Bob Phillips

"Sam via OfficeKB.com" <forum@OfficeKB.com> wrote in message
news:519C5C034A568@OfficeKB.com...
>
> 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

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

--
HTH

Bob Phillips

"Sam via OfficeKB.com" <forum@OfficeKB.com> wrote in message
news:519C5C034A568@OfficeKB.com...
>
> 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