Forum Discussion
Dragging formulas
Can anyone help with this, I am trying to drag formulas horizontally from different workbook tabs. However when I drag formula it changes the cell rather than the workbook. i.e. following on...
I'm afraid that is how dragging (or copying) formulas work in Excel; they always only update cell references, not worksheet names. I would do this:
- In cell A1 put the number 34
- In B1 =A1+1, copy cell B1 to the right as far as needed
- In cell A2 write a formula like this one:
="='"&A1&"'!E47
- Drag this to the right
- Copy the cells on row 2
- Paste special Values
- Do a Search and replace, search for = and replace by =