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
|
|||
|
|||
assistance need with excel doc
Hi guys
I am trying to copy rows which has minor function. These 5 rows have titles and a functions displaying items from another sheet. I tried to multiply (copy) these rows buy dragging the mouse down the sheet, but it makes copies with the function adding 5 instead of + 1. e.g "=Evaluation!C5&Evaluation!AY5&Evaluation!D5", the next set would be "=Evaluation!C10&Evaluation!AY10&Evaluation!D1 0" instead of "=Evaluation!C6&Evaluation!AY6&Evaluation!D6". I would like to know if I could copy these 5 rows a set adding + 1 for the formula instead of + 5? asssistance is highly appreciated, thanx Geno |
#2
|
|||
|
|||
assistance need with excel doc
Geno,
The easiest thing would be to select the cell with the formula, press F2 to enter edit mode, use Shift-home, then Ctrl-C to copy the formula string, select the cell ABOVE where you want the copy to be located, press F2 then Ctrl-V to paste the formula string, and then press Enter. Copy that cell and paste it one row down, and then delete it. Otherwise, you could use a macro, or use a formula like =OFFSET(Evaluation!$C$5,ROW(A5)/5-1,0) for each of your links. HTH, Bernie MS Excel MVP "GENO" wrote in message ... Hi guys I am trying to copy rows which has minor function. These 5 rows have titles and a functions displaying items from another sheet. I tried to multiply (copy) these rows buy dragging the mouse down the sheet, but it makes copies with the function adding 5 instead of + 1. e.g "=Evaluation!C5&Evaluation!AY5&Evaluation!D5", the next set would be "=Evaluation!C10&Evaluation!AY10&Evaluation!D1 0" instead of "=Evaluation!C6&Evaluation!AY6&Evaluation!D6". I would like to know if I could copy these 5 rows a set adding + 1 for the formula instead of + 5? asssistance is highly appreciated, thanx Geno |
Thread Tools | |
Display Modes | |
|
|