Autofill issue
Oops, Jean please ignore the below post. I misread..
--
If this post helps click Yes
---------------
Jacob Skaria
"Jacob Skaria" wrote:
In A12
=A10*J1
Copy the cell. Select the required cells from A13 to An. Right clickPaste
SpecialFormulas..OK
If this post helps click Yes
---------------
Jacob Skaria
"Jean" wrote:
I am trying to autofill a formula. I am in cell A12. Assuming that I want
to multiply A10*J1. When I autofill it across, I would like the A10 to
change to A11, A12, etc. However, I want the J1 to change to J2, J3, etc.
Absolutes will not work. I'm sure that this isn't simple multiplication.
Does anyone have a function that will do this? Thanks.
|