How do I copying data from a cell on sheet to a diff cell/sheet
in [Functions]
|
From: Bowldiva120 on 21 Mar 2010 13:08 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?
From: Max on 21 Mar 2010 19:25 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? >
|
Pages: 1 Prev: Combine macros variable help Next: Automating a worksheet in Excel 2003 |