+ Reply to Thread
Results 1 to 2 of 2

Macro to transpose the data from tab to another sheet

  1. #1
    Registered User
    Join Date
    10-28-2012
    Location
    Poland
    MS-Off Ver
    Excel 2007/2010
    Posts
    94

    Macro to transpose the data from tab to another sheet

    Hi,
    I'm tried to create makro which will transform(transpose) data from one tab to another. I present that on attachech picture and in the file.
    I was trying to create makro which will populate the names from column A,B,C and transpose the data from column F till Q, but I failed.... I think picture describe it better than me

    Is it possible tocreate the macro which will go through whole sheet and paste transposed dataa to new one?

    If anyone will be able to support me I will really appreciate that. Also if any detailed explanation needed feel free to contact me.
    Attached Images Attached Images
    Attached Files Attached Files
    Like to say thanks ?Please use the star icon.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,278

    Re: Macro to transpose the data from tab to another sheet

    Give this a try

    Please Login or Register  to view this content.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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. Transpose data to another sheet using macro
    By geliedee in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-29-2015, 03:49 PM
  2. [SOLVED] Automatically transpose the data in sheet 1 rows into columns in sheet 2.
    By Azalea11 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 12-16-2014, 11:07 AM
  3. [SOLVED] VBA / Macro / Formula help needed for extracting data and Transpose into another sheet
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-05-2014, 12:19 PM
  4. Macro to transpose data from one sheet to another
    By Cupragsw in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-26-2013, 12:17 PM
  5. [SOLVED] Macro to transpose vertical data horizontally from one sheet to another
    By Scott_88 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-09-2013, 06:27 AM
  6. [SOLVED] How to copy data range form one sheet to other sheet with desire Reverse Transpose ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-18-2013, 12:30 PM
  7. [SOLVED] Manipulate and transpose data to another sheet via a Macro
    By Phil_MacRae in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-12-2012, 02:22 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