You can use the INDEX function to refer to your RAWDATA sheet, as such:

=INDEX(RAWDATA!$A$1:$J$23,ROW(3),1)

This will return the data from A3 regardless of how many rows are
inserted between A1 and A3.

There are various approaches to writing this formula, depending on your
data layout, e.g.:

=INDEX(RAWDATA!$A$1:$J$23,ROW(),1) Will return the the value from the
matching row that contains the formula and the row within the data
range, e.g. if this formula is in G21 on DisplayData, it will return
the value in A21 on RAWDATA. Similarly,
=INDEX(RAWDATA!$A$1:$J$23,ROW(),COL()) in the same G21, would return
the value from G21.

Will this meet your needs?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=476270