Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assign Color to a Cell based on another Cell on a diff Sheet | Excel Worksheet Functions | |||
Why copying the sheet to diff file changes font color? | Excel Worksheet Functions | |||
Copying values from one sheet to the same cell in another sheet | Excel Discussion (Misc queries) | |||
need help please inserting multiple rows based on cell value then copying to data sheet | Excel Worksheet Functions | |||
copying same cell diff worksheets to new sheet | Excel Discussion (Misc queries) |