Copy Paste Reference Formulas (but need it to skip)
Posted by CPU Nut on October 13, 2001 9:15 AM
I've always thought I knew a bit about Excel, but this one has me stumped. I am trying to copy and paste a formula into the next several 1,000) rows. The formula refers to another worsheet.
The next cell down that I copy this into, if I just use copy and paste, will automatically changes the formula to
I need it to say
I basically want it to skip 2 lines for every cell I paste it into in sequence. I could copy and paste down a 1,000 rows and go back and delete every other 2 lines, but there's gotta be a better way. Please email me if you need me to send you what I am working on. Its a real simple worksheet but it will be alot of work otherwise. appreciate the help!! I actually have another one that I'll ask in the near future!!! I'll try and help others if I can, I'm new to this board.