Copy rows but need to refer to same cell in original formula
On Apr 4, 10:03*am, addison wrote:
I need to copy/paste 5 original rows multiple times in worksheet but need
formula to refer back to same static amount in cell k3. *How can I do this
without having to go to each newly created cell and change it to k3 in
formula? *That would take hours for me to do.
Thanks!
If I catch your drift, make K3 an absolute reference: $K$3. . .or am I
missing something phenomenological?
Pierre
|