Formula copying

**chester** · 08-03-2009, 10:31 AM

i seem to have a problem where im copying the formula in the same column but down one row and the formula isnt shifting taking the new cells into account. its keeping the previous rows formula. i dont know what im doing wrong.

**Richard Schollar** · 08-03-2009, 10:33 AM

Hi & Welcome to the Board!

Are you using code to do this or manually doing it in the Excel interface? If code, please post all the code you are using.

Richard

**dominicb** · 08-03-2009, 10:35 AM

Good afternoon chester

...and welcoem to the forum!!

Originally Posted by chester

i seem to have a problem where im copying the formula in the same column but down one row and the formula isnt shifting taking the new cells into account. its keeping the previous rows formula.

It sounds like the formula you are copying down are absolute rather than relative. Do they have lots of dollar signs in them?

Post the formula you are struggling with and someone can tell you if that's the case, and, more importantly, what to do about it.

HTH

DominicB

**chester** · 08-03-2009, 10:43 AM

=SUM(F6*0.4)

im right clicking on the cell with the content formula, then moving the cursor to the row below in the same column, right clicking it and pasting it in. i dont know how to tell if its absolute of relative. sorry im a novice!!!

**Richard Schollar** · 08-03-2009, 10:57 AM

That's a relative formula so it should update (incidentally, the Sum is redundant, you could just use =F6*0.4). Is the cell returning a value currently rather than just showing the formula?

Richard

**chester** · 08-03-2009, 11:08 AM

hi there.

yes, it is retaining a figure but its keeping the same formula above, just simply copying it down.

**Richard Schollar** · 08-03-2009, 11:38 AM

You're not Cutting rather than Copying are you?

**chester** · 08-04-2009, 09:38 AM

hi there.

no im definitely copying and not cutting.

**Richard Schollar** · 08-05-2009, 09:26 AM

Are you physically copying the cell itself? You aren't for example copying the text in the formula bar at the top of the screen and pasting that?

**romperstomper** · 08-05-2009, 10:45 AM

Move your cursor to the bottom right corner of the cell with the original formula (the cursor should change to a black + sign) then hold down the left mouse button and drag down as far as you want to fill and then release the button. If you have data in the column to the left, you can also double-click on the bottom right corner rather than dragging down.