Hi Ron,

Thanks a lot for additional input. Much appreciated.

Cheers,
Sam

Ron Rosenfeld wrote:

Enter this formula in some cell:

=INDEX(Data,ROWS(Data)-ROWS($1:1)+1,COLUMNS($A:A))

Fill down ten rows and across eight rows.

If you need to check that you don't fill down more than ten or across more than
the number of columns, you can use this instead, which returns a null string if
you go to far:

=IF(OR(COLUMNS($A:A)COLUMNS(Data),
(ROWS(Data)-ROWS($1:1)+1)<=(ROWS(Data)-10)),"",
INDEX(Data,ROWS(Data)-ROWS($1:1)+1,COLUMNS($A:A)))
--ron

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