+ Reply to Thread
Results 1 to 4 of 4

Macro to reformat the data in Output sheet

  1. #1
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 365
    Posts
    258

    Smile Macro to reformat the data in Output sheet

    Hi all :-)

    Hope, that here is somebody, who will be able to help me.

    I have a shift plan for my agents for each daiy with some results == "Input Sheet".

    What I need is to somehow transpose input data to "Output" sheet. Example attached, where start date and end date is always the same. So basically somehow transpose data from column to rows according to the example.

    Not sure, if there is easier way to create it

    Thaaaank you,
    Andy
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to reformat the data in Output sheet

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 365
    Posts
    258

    Re: Macro to reformat the data in Output sheet

    Super, that works awesome

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to reformat the data in Output sheet

    Glad to hear that. Thanks for the feedback and the rep.

+ 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. Can I use excel macro to reformat the output results of dir *.* /s
    By jaytaba in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-05-2013, 05:16 PM
  2. [SOLVED] Need macro to reformat data
    By s4driver in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-16-2013, 02:39 PM
  3. [SOLVED] Need dynamic macro to reformat data from one tab to another
    By s4driver in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-25-2013, 01:12 PM
  4. [SOLVED] Reformat Certain Data onto Another Sheet?
    By stusic in forum Excel General
    Replies: 5
    Last Post: 11-07-2012, 12:08 AM
  5. [SOLVED] Macro to reformat raw data in a different worksheet
    By schaasyd in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2012, 07:40 AM
  6. Replies: 1
    Last Post: 12-21-2011, 01:50 PM
  7. Replies: 0
    Last Post: 05-02-2011, 10:22 AM
  8. looping macro to reformat data from one sheet to another
    By johngombola in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2009, 12:08 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