So here is what I did.
I created another worksheet like this. Please refer to the PDF attachment INDIRECT FORMULA.
I typed the different parts of the formula into seperate cells.
Typing the absolute reference as text in D1 allowed me to auto-fill down giving me $M$1, $M$2, $M$3, and so on.
I typed in a combining formula, which you can see in cell F1, to combine all of the cells and create the complete formula I need for my other workbook as a result. Then I selected cells A1, B1, C1, D1, E1, and F1 and auto-filled down 1000 rows. Finaly, I selected and copied column F and then paste specialed the values only in column G.
That left me with one problem. Even though column G contains the new formula, Excel reads it as text unless I double-click on each individual G cell and press enter. Then Excel reads it as the formula it's supposed to. I've got thousands of these formulas. Does anyone know of a way to make Excel read all them as a formula with just a few clicks of a button?
Bookmarks