Copy formula in excel from one sheet

November 15, 2010 at 11:01:23
Specs: Windows 7, 1
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

See More: Copy formula in excel from one sheet

Report •

November 15, 2010 at 16:29:44
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 this How-To.

Report •
Related Solutions

Ask Question