+ Reply to Thread
Results 1 to 4 of 4

macro to transpose data

  1. 06-07-2014, 10:43 PM #1
    rhoda20
    rhoda20 is offline
    Registered User
    Join Date
    05-20-2014
    Posts
    2

    macro to transpose data

    Help! I need macro to transpose the raw data I have extracted from a Biometrics file into the format I need to compute for work hours.
    Please see attached file.

    Sheet 1(raw data)
    Sheet 2 ( format i want the data to look like)

    thanks,
    rhoda
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-08-2014, 01:10 AM #2
    k64
    k64 is offline
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: macro to transpose data

    Try this: 
    Please Login or Register  to view this content.
    1. Include a sample workbook with an example of the result you want
    2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
    3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.
    Reply With QuoteRegister To Reply
  3. 06-08-2014, 03:08 AM #3
    rhoda20
    rhoda20 is offline
    Registered User
    Join Date
    05-20-2014
    Posts
    2

    Re: macro to transpose data

    Great it works! thanks so much!
    Reply With QuoteRegister To Reply
  4. 06-08-2014, 08:39 AM #4
    k64
    k64 is offline
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: macro to transpose data

    You're welcome. Glad I could be helpful
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to Transpose Data
    By erock24 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-17-2020, 01:07 AM
  2. [SOLVED] Macro To Transpose Data
    By AlexRoberts in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2014, 09:33 AM
  3. Help with macro to transpose data
    By ejecheche in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-03-2012, 06:26 AM
  4. Transpose Data Macro
    By Jakila2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2011, 03:56 PM
  5. Macro to Transpose the data
    By pandyav in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-10-2010, 05:51 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1