I have a question on formulas and dragging formulas to automatically populate cells with the same formula.
I'm using Excel 2003 on a Windows XP system.
I have a formula in one worksheet(tab) that references a cell in another worksheet. I would like to drag the formula down in the first worksheet so that it automatically populates the cells below or next to it with the same formula. Traditionally, Excel will just increase all the references cells by one cell. So, for instance if your formula is "=100+A1", when you drag it down the formula will become "=100+A2". What happens if you don't want it to always increase by "1"? What if you want it to skip cells or rows, so that your formulas become "=100+A1", "=100+A4", "100+A7"? In this example, the formulas increase by 3 each time.
And an even more advanced question is, what if you wan the formulas to swich sheets? For example, "=100+'Shee1"!A1", "=100+'Sheet2'!A2", and so on?
Is there a way to do this?
Thanks!
I'm using Excel 2003 on a Windows XP system.
I have a formula in one worksheet(tab) that references a cell in another worksheet. I would like to drag the formula down in the first worksheet so that it automatically populates the cells below or next to it with the same formula. Traditionally, Excel will just increase all the references cells by one cell. So, for instance if your formula is "=100+A1", when you drag it down the formula will become "=100+A2". What happens if you don't want it to always increase by "1"? What if you want it to skip cells or rows, so that your formulas become "=100+A1", "=100+A4", "100+A7"? In this example, the formulas increase by 3 each time.
And an even more advanced question is, what if you wan the formulas to swich sheets? For example, "=100+'Shee1"!A1", "=100+'Sheet2'!A2", and so on?
Is there a way to do this?
Thanks!