Move Cell Location Keep Formulas Functioning

[billy60]

Hello,

I would like to move cell formula K19 to K9 without changing results in other parts of sheet formulas.

Can this be done please? I want to make the register into a table is why.

Thank you

[JohnTopley]

K19 has "=K5" so move/use K5 (=SUM($F$10:$F$11)) formula ?

[billy60]

I tried to cut and paste from K19 to K9 but it changes things.

[JohnTopley]

Set K9 "=SUM($F$10:$F$11)"

[billy60]

If I delete contents of K19 it changes things.

[billy60]

Why can't I cut and paste from K19 to K9?

[JohnTopley]

in K20

Please Login or Register  to view this content.

[billy60]

I tried that and copied down but the amounts aren't the same.

[JohnTopley]

Did I say copy down?

[billy60]

Thanks but I really wanted to make this into a table is the reason why I wanted to move the formula in cell K19. The main reason for a table is to have slicers.

[JohnTopley]

There is no formula in K19!

[billy60]

Thanks for the help but it seems this template cannot be made into a table for slicers.

[JohnTopley]

I created a table and associated slicer(s) - and I am a "novice" with regard to slicers! - no problem.

[billy60]

Thanks but could not sort table so I have this other version that functions. It will need some editing but here you go.