How do I copying data from a cell on sheet to a diff cell/sheet

[Bowldiva120]

It data entry of scores on worksheet one that has to be automatically copied
to worksheet 2. Once I entry the data on wksht 1 want it placed on wksht 2.

I run tournaments, need all of the date on worksheet 1 but only some on
worksheet 2 so I can sort it. When I set up my wksht 2 us the formula
=wksht1!C4 on the first line. the on the second line input =wksht1!C11
then highlight the two and drag it down. It will copied what i inputed but
won't calculte and change the cell referrence by 7 how do I get it to do that
without having to manually change the number?

 

[Max]

To get it to propagate in this manner ...

=wksht1!C4 on the first line. the on the second line input =wksht1!C11

Use this in any startcell: =INDIRECT("'wksht1'!C"&ROWS($1:1)*7-3)
Copy down as far as required. Success? hit YES below