+ Reply to Thread
Results 1 to 3 of 3

Transform Data from A1,b1,C1 to A50,A51,A52

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Transform Data from A1,b1,C1 to A50,A51,A52

    Hello,
    This may be easy for lot of you.
    I need a macro which will Copy Data from say A1,B1,C1,D1,E1 to
    say A50,A51,A52,A53,A54 (Then leave 1 row blank)
    Copy Data fromA2,B2,C2,D2,E2 to A56,A57,A58,A59,A60 (Then leave 1 row blank)....

    Attach sheet will explain you my purpsose....

    Thank U

    Riz Momin
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628
    See the attached file... I added the macro 'macro1' in 'Apr07' sheet.

    I hope it's what you need.

    Regards,
    Antonio
    Attached Files Attached Files

  3. #3
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Transform Data from A1,b1,C1 to A50,A51,A52

    Thank You so much ...

    It works

    Riz Momin

+ 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