On row 5 the formula

=INDIRECT("Sheet1!B"&((ROW()-4)*10))

will access cell B10 from Sheet1, and each 10th row as you drag down.


Georgyneedshelp Wrote:
In order to work out exactly where I'm going wrong, I'm going to
explain
exactly what I'm doing so somebody might be able to help me! Sorry if
it
seems boring, but I need to work this out to help my 3rd year
university
project!

I have data in sheet 4 and in every tenth row, I have data that I want
to
put into sheet 5. In Sheet 5 A5 (the first cell I want to write
anything in),
I have written =Sheet4!40 . The row below that, I have then written
=Sheet4!50 . I want the formula to then go up in tens, as in =Sheet4!70
,
=Sheet4!80 but instead it always puts the wrong thing in. I have
written the
correct formula up to A13 so that I have ten bits of correct data, but
this
hasn't helped.

Thank you.

Georgyxx


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=476184