+ Reply to Thread
Results 1 to 4 of 4

how to move cells

  1. #1
    Registered User
    Join Date
    04-24-2015
    Location
    London
    MS-Off Ver
    2007
    Posts
    3

    how to move cells

    Hello guys,

    I would appreciate if someone could explain how to make this work. Basically I want that when I change the number in the cell let say from 34 to 2. That the small number went up. I uploaded picture to explain this, I hope it makes sense. Thank you in advance.

    Picture.jpg

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: how to move cells

    I think that you want your data to be sorted automatically.

    This requires a sheet specific macro, I will create one for you.

    When I have, right click on the sheet name at the bottom of excel and select view code.

    Paste my code there and then close the Macro module.

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 05-03-2015 at 02:38 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    04-24-2015
    Location
    London
    MS-Off Ver
    2007
    Posts
    3

    Re: how to move cells

    Thank you very much for your help much appreciated.

  4. #4
    Registered User
    Join Date
    04-24-2015
    Location
    London
    MS-Off Ver
    2007
    Posts
    3

    Re: how to move cells

    Right, I managed to move cells in column B. But how could I move content in A and B columns together? Thank you once again

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Move cells based on cell length *shift cells right) - code required
    By pauldaddyadams in forum Excel Programming / VBA / Macros
    Replies: 49
    Last Post: 11-21-2014, 08:56 AM
  2. Replies: 1
    Last Post: 11-09-2013, 06:11 AM
  3. Move and size with cells greyed out- form control checkboxes move after printing 2010
    By Duffy1974 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-26-2012, 09:19 AM
  4. have reference cells move in rows while I move in columns
    By gryffin13 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2011, 09:33 AM
  5. How to click macro - Move right 15 cells - Next click move back to home position
    By Launchnet in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-05-2010, 10:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1