I have a quick question. I have some complex forulas that I need to copy to the right but what I need is not working maybe someone can help me. Ill set up and example.
Lets say I have 1 in cell A3 and 2 in cell A4 and so on down through 25 in cell A27. Now I have =$A3 in cell B2 and =$A4 in cell C2. I want to copy those formulas to the right until I get =$A27 in cell Z2. When I copy the formula to the right it give me =$A3 in cell D2 instead of =$A5 & =$A4 in E2 instead of =$A6. Hopefully this all makes sense and there is something easy that I am just missing. Thanks for your time.