LinkBack URL
About LinkBacks
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
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
K19 has "=K5" so move/use K5 (=SUM($F$10:$F$11)) formula ?
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
I tried to cut and paste from K19 to K9 but it changes things.
Set K9 "=SUM($F$10:$F$11)"
If I delete contents of K19 it changes things.
Why can't I cut and paste from K19 to K9?
in K20
Formula:
Please Login or Register to view this content.
I tried that and copied down but the amounts aren't the same.
Did I say copy down?
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.
There is no formula in K19!
Thanks for the help but it seems this template cannot be made into a table for slicers.
I created a table and associated slicer(s) - and I am a "novice" with regard to slicers! - no problem.
Thanks but could not sort table so I have this other version that functions. It will need some editing but here you go.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks