assistance need with excel doc

  • Thread starter Thread starter GENO
  • Start date Start date
G

GENO

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!D10" 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
 
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
 
Back
Top