+ Reply to Thread
Results 1 to 6 of 6

Shifting columns in a workbook

  1. #1
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Shifting columns in a workbook

    Hello Experts,

    I have a workbook with 12 sheets where Column A is Blank column B is details and column C to column N I have months (Jan’13, Feb’13,Mar’13…….) Column O has Year to Date Total 2013. In Column P to AA I have Jan’14 through Dec’14 and Column AB has Year to Date column.
    Structure/Layout of all the worksheets is same

    What I want to achieve is:

    For each worksheet in the workbook place Months next to each other so that columns show:
    Column C: Jan’13
    Column D: Jan’14
    Column E: Feb’13
    Column F: Feb’14
    .
    .
    .
    Column AA: YTD 2013
    Column AB: YTD 2014

    Attached, is a workbook showing how columns currently look

    Best Regards/VKS
    Attached Files Attached Files

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Shifting columns in a workbook

    maybe something like this
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: Shifting columns in a workbook

    Thanks a lot Nilem. As always you have been a great help......
    FYI Macro Recorder gave me a code that is 64 rows long and almost each row has select next row starts with selection

    How do I modify this to run on each worksheet of the workbook...
    Best Regards/VKS

  4. #4
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Shifting columns in a workbook

    try
    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: Shifting columns in a workbook

    Sorry Nilem,
    Second code does nothing.
    Best Regards/VKS

  6. #6
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    521

    Re: Shifting columns in a workbook

    Hello Nilem

    Just to share with you and for the benefit of other users:

    Upon changing

    Please Login or Register  to view this content.
    To
    Please Login or Register  to view this content.
    Worked as fast as first one did on single sheet
    Thanks a lot once again for your help.
    You are a star

+ 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. Shifting and combining columns using VBA
    By texas979 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2013, 03:02 AM
  2. Automatic shifting of cells to different columns
    By Jacana in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2013, 06:48 AM
  3. [SOLVED] shifting columns
    By clc3 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2012, 12:00 PM
  4. Images shifting w/in Workbook????
    By hamzadeh in forum Excel General
    Replies: 0
    Last Post: 09-11-2009, 10:28 AM
  5. [SOLVED] Columns Shifting on Import of Data
    By Carroll in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2005, 12:06 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