I would like to copy a formula from one excel sheet in the same workbook to another. =SUM(NOMINEES!C8:C11) my next row i need the formula to be =SUM(NOMINEES!D8:D11) but when i try it goes to =SUM(NOMINEES!C9:C12)

Hope somoneone can guide me

Thanks

I'm sure there's more to this than you've told us, but one way to get what you want is to try this: 1 - Copy the formula into the cell in the next column, which will give you the column offset that you want

2 - Move your cursor over the outline of the cell until it turns into 4 arrows

3 - Drag the cell contents to the cell where you want it and it will retain the column offset.

Posting Tip:Before posting Data or VBA Code, read thisHow-To.

Ask Your Question

Weekly Poll