Results 1 to 5 of 5

Thread: Moving values in columns with formula

  1. #1

    Moving values in columns with formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi

    i wonder if there any formula or macro that automatically moving values in a column under it's column.
    for example i have a data with 11 columns (Date,Jan,Feb..Okt. *i attach the example of my data) and i want to move the columns on Feb under the Jan Column. and then i want to move the March Column under Jan column and so on. All i can do right now is just use manually copy-paste the values. but it's frustating when i work in large database.
    any solution? thx in advance.
    Attached Files Attached Files

  2. #2
    Admin Alumnus Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,760
    Articles
    0
    Excel Version
    2010 on Xubuntu
    If you have to repeat this operation on a regular basis you could record a macro that

    or moves the ranges as required
    or replaces the column titles as required then applies a sorting by columns ( maybe you'll have to add the tool to your ribbon)

  3. #3
    thank you for your quick respond. i'll try it

  4. #4
    Admin Alumnus Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,760
    Articles
    0
    Excel Version
    2010 on Xubuntu

  5. #5

    cross post link

    sorry. how do i fixed it. can't find edit my post here

Tags for this Thread

Posting Permissions

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