CrazyEngineers
CrazyEngineers

  • How to move information from one row/column to other when we change information in other cell??

    Kanagavel90

    Member

    Updated: Oct 23, 2024
    Views: 916
    Hey guys..,
    Recently I have got a problem with microsoft excel..let me put as simple as i can,If i have a value in one cell (say k2) and also i have numbers in n2,o2,p2,etc..My doubt is if i change the value in cell k2,Is there any possibility that n2 values move to o2 and o2 value move to p2 and so on..Is there any formulas to apply?? Would it possible to do so??

    Thanks & Regards

    A.Kanagavel.
    0
    Replies
Howdy guest!
Dear guest, you must be logged-in to participate on CrazyEngineers. We would love to have you as a member of our community. Consider creating an account or login.
Replies

  • rahul69

    Member • Feb 28, 2013

    Actually I could not follow what exactly you wanted to know, but I think this could be the solution: if you right click and click on insert option, you will get many choices and I guess one of those will be what you are looking for.
    Hope it helps!
    Are you sure? This action cannot be undone.
    Cancel

  • Kanagavel90

    Member • Feb 28, 2013

    rahul69
    Actually I could not follow what exactly you wanted to know, but I think this could be the solution: if you right click and click on insert option, you will get many choices and I guess one of those will be what you are looking for.
    Hope it helps!
    Actually Its not that much easy to do so..I was wondering if i have formulas or to use any logical options in those main menus..Because i am trying to move a value from one cell to other automatically...
    Are you sure? This action cannot be undone.
    Cancel

  • Kaustubh Katdare

    Administrator • Feb 28, 2013

    I need to understand this first. I'm guessing that you want to 'move' the values in cell to the 'right'. The question is - what should really trigger this action? Would incrementing the value in K2 act as a trigger to initiate the movement of values in cells to right?

    Do the cells that contain data have a formula in them?
    Are you sure? This action cannot be undone.
    Cancel

  • Kaustubh Katdare

    Administrator • Feb 28, 2013

    I need to understand this first. I'm guessing that you want to 'move' the values in cell to the 'right'. The question is - what should really trigger this action? Would incrementing the value in K2 act as a trigger to initiate the movement of values in cells to right?

    Do the cells that contain data have a formula in them?
    Are you sure? This action cannot be undone.
    Cancel

  • Kanagavel90

    Member • Feb 28, 2013

    Nope.The cell doesnt have any formula..In K2 cell I have date as 1/3/2013, and I have value in n2,02,p2 and so on..For this n2,o2,p2 I have put dates on top of these rows.If i change date in k2, cell values should go to their respective date columns.
    Hope u understand this..
    Are you sure? This action cannot be undone.
    Cancel

  • Kanagavel90

    Member • Feb 28, 2013

    Nope.The cell doesnt have any formula..In K2 cell I have date as 1/3/2013, and I have value in n2,02,p2 and so on..For this n2,o2,p2 I have put dates on top of these rows.If i change date in k2, cell values should go to their respective date columns.
    Hope u understand this..
    Are you sure? This action cannot be undone.
    Cancel
Home Channels Search Login Register