How do I use paste special/multiply so that when I copy a cell then multiply, it uses the cell reference instead of the number in that cell. I.E. I have in A5, =a3, and in a1 have 25, but I want in a5, =a3/a1. I ask because I have several thousand formulas to modify to add/divide/multiply by only 3 different cells. Or is there an easier way to do this?
Thanks!
Thanks!