1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Visual Basic Macro for Excel 2002 columns to rows in new sheet using unbalanced data

Discussion in 'Business Applications' started by jadranka, Dec 8, 2012.

Thread Status:
Not open for further replies.
Advertisement
  1. jadranka

    jadranka Thread Starter

    Joined:
    Dec 8, 2012
    Messages:
    2
    I need a visual basic macro for excel 2002 that will do the following:

    From sheet1:ColumnA
    Select rows until sheet1:columnA value does not start with REC (as the no of rows is unbalanced, sometimes 7 rows, sometimes 10 rows, sometimes 8 rows, etc)
    copy selected rows and transpose to sheet2:columnA to however many rows were selected

    Repeat until end last row


    My real table has 30000 rows and the rows are unbalanced

    I am attaching a test file.

    Please help me and thank you for your support and time. :rolleyes:

    Tech Support Guy System Info Utility version 1.0.0.2
    OS Version: Microsoft Windows XP Professional, Service Pack 3, 32 bit
    Processor: Pentium(R) Dual-Core CPU E5300 @ 2.60GHz, x86 Family 6 Model 23 Stepping 10
    Processor Count: 2
    RAM: 2047 Mb
    Graphics Card: ATI Radeon HD 4300/4500 Series, 1024 Mb
    Hard Drives: F: Total - 99998 MB, Free - 30856 MB; G: Total - 205236 MB, Free - 153405 MB; H: Total - 305168 MB, Free - 180367 MB;
    Motherboard: MICRO-STAR INTERNATIONAL CO.,LTD, G31M3-L V2(MS-7529)
    Antivirus: None
     

    Attached Files:

  2. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    Can you also attach a second workbook showing how the data should appear after the macro is run?

    Regards,
    Rollin
     
  3. jadranka

    jadranka Thread Starter

    Joined:
    Dec 8, 2012
    Messages:
    2
    The output is on sheet2 of the same workbook. thanks for replying.
     
  4. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    In your sample workbook that you posted there is nothing on Sheet 2 or Sheet 3.


    Rollin
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Similar Threads - Visual Basic Macro
  1. americamba
    Replies:
    5
    Views:
    219
  2. nomad
    Replies:
    1
    Views:
    172
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/1080037

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice