Results 1 to 6 of 6

Shifting columns in a workbook

Threaded View

VKS Shifting columns in a workbook 03-13-2014, 02:33 AM
nilem Re: Shifting columns in a... 03-13-2014, 03:01 AM
VKS Re: Shifting columns in a... 03-13-2014, 03:15 AM
nilem Re: Shifting columns in a... 03-13-2014, 03:41 AM
VKS Re: Shifting columns in a... 03-13-2014, 03:54 AM
VKS Re: Shifting columns in a... 03-13-2014, 08:06 AM
  1. #1
    Forum Contributor
    Join Date
    11-11-2012
    Location
    Muscat, Oman
    MS-Off Ver
    Office 365
    Posts
    522

    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

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