+ Reply to Thread
Results 1 to 7 of 7

need vba code to copy set of data in row to column

  1. #1
    Registered User
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2007
    Posts
    85

    need vba code to copy set of data in row to column

    Dear experts

    I have set of data in sheet rawdata which is in row down as set of data need to copy column in separate header value

    please find the attachment
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,538

    Re: need vba code to copy set of data in row to column

    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    06-27-2010
    Location
    sYRIA
    MS-Off Ver
    Excel 2013
    Posts
    427

    Re: need vba code to copy set of data in row to column

    Hi
    Please Login or Register  to view this content.
    Last edited by mohadin; 04-11-2021 at 07:49 AM.

  4. #4
    Registered User
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2007
    Posts
    85

    Re: need vba code to copy set of data in row to column

    WorKs Amazing but small END WITH "error 9 subscript out of range"
    Attached Images Attached Images
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2007
    Posts
    85

    Re: need vba code to copy set of data in row to column

    Thanks for perfect code which is works amazing one thing which is not copy data till end of row where it ends of data

    please find real data in xls
    Attached Files Attached Files

  6. #6
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,538

    Re: need vba code to copy set of data in row to column

    Change
    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2007
    Posts
    85

    Re: need vba code to copy set of data in row to column

    Thanks it works perfectly

+ 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. [SOLVED] How does the VBA code copy the data in column A to the merged cell in column D?
    By rayhen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-03-2020, 09:52 AM
  2. [SOLVED] VB Code to copy paste data from column to another column based on content of cell
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2019, 08:50 PM
  3. [SOLVED] VBA code: copy/paste data from 2 two columns into one column
    By Tapyr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-23-2015, 07:19 AM
  4. VBA to copy down Vlookup VBA code in Column till last available data
    By shansakhi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-15-2014, 08:09 AM
  5. [SOLVED] Find a value in a column and copy all data above that row code not working.
    By klunker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2014, 08:44 AM
  6. [SOLVED] VBA code to copy column data only if headers match
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-13-2012, 11:23 PM
  7. VBA Code to copy data from last filled column and paste to the next available column.
    By Pavman2473 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-09-2012, 09:07 PM

Tags for this Thread

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