Copy and Paste

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Hi,
I have a lot of grouped formulas. I want
to reuse some with copy and paste. But when
I try to paste excel changes the number of
cells in the formula.
Like SUMPRODUCT(--(Admin!F1:F10000=1),--(Admin!
H1:H10000=8)) to


=SUMPRODUCT(--(Admin!F5:F10004=1),--(Admin!H5:H10004=8))


I went in the PASTE SPECIAL
but nothing to paste the same cells values....!!!!


THanks if you have an idea...

Jack
 
Hi
look at the help for relative versus absolute references. for your
example use
SUMPRODUCT(--(Admin!$F$1:$F$10000=1),--(Admin!$H$1:$H$10000=8))
 
Jack,

The cells that you want to remain constant must be entered as absolute
values i.e. $F$1: $F$10000. (The $ sign in front of F locks down the
column; $sign in front of just the 1 locks down the row)
You can do this by placing the cusor within the address and pressing
the F4 function key
 
Back
Top