Probably a simple Excel copy/paste issue...
workbook. I have a value in cell (E1, in this case), and a formula that references that cell. In the example, that formula in cell E3 is =D3/(1-(E1/100)). I want to copy and paste that formula into a bunch of other cells (a few in my example, but in practice it is hundreds). When I do this, the formula changes to =D3/(1-(E2
/100)), and so on, instead of always staying at E1. This results in a bunch of #VALUE! errors, and depending on how the sheet is laid out, this stair-stepping can sometimes start referencing cells with data in them, producing wildly incorrect results.
So what I'm wanting is when I copy E3 in my example sheet, and paste it into E4 through E8, I want the formula in E4 to say =D4/(1-(E1/100)), and E5 should say =D5/(1-(E1/100)), and E6 should say =D6/(1-(E1/100)), and so on.... the first part changing, but always referencing E1 for the latter part.
Is there a way to make paste do this? Or a better/easier way of accomplishing the same end result? What I don't want is to have rows and rows of the same value (E1's value), just to make the pasting work.
I swear I've done this before, and pretty simply, but for the life of me I can't remember how, and Excel's help is not turning up anything relevant.