If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I copying data from a cell on sheet to a diff cell/sheet
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? |
#2
|
|||
|
|||
How do I copying data from a cell on sheet to a diff cell/sheet
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 -- Max Singapore --- "Bowldiva120" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|