+ Reply to Thread
Results 1 to 4 of 4

Convert specific rows into columns in Sheet 2 - VBA

  1. #1
    Forum Contributor
    Join Date
    08-08-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    196

    Convert specific rows into columns in Sheet 2 - VBA

    Dear all,

    I am writing to request any assistant in creating a macro which can read and extract specific rows from "Sheet1" and paste it in Sheet2 as Column List as shown in the workbook example.

    Final_Data_Extraction.xlsm

    Any help with task would be very much appreciated. Thank you for your time and help.

    Kind regards

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,144

    Re: Convert specific rows into columns in Sheet 2 - VBA

    You can use this formula in D2 and then drag it down

    Please Login or Register  to view this content.

  3. #3
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,140

    Re: Convert specific rows into columns in Sheet 2 - VBA

    hi missy22, just a simple copy & paste values code as an alternative:

    Please Login or Register  to view this content.

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  4. #4
    Forum Contributor
    Join Date
    08-08-2012
    Location
    london
    MS-Off Ver
    Excel 2010
    Posts
    196

    Re: Convert specific rows into columns in Sheet 2 - VBA

    Dear benishiryo, Thank you so much for reply and help. The code works great...you're Star!

    Thank you all for your response and help.

    I really appreciate your time and help.

    Have a wonderful day.

    Kind regards
    Misbah

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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