Results 1 to 2 of 2

Thread: Excel VBA to copy and paste data on different worksheet

  1. #1

    Excel VBA to copy and paste data on different worksheet

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi! i need your a vba loop to copy data in Sheet1 and paste it in Sheet2

    I have this data in Sheet1.

    The number of rows is unknown but the pattern is the same.

    CoumnA ColumnB
    fruit1 pears
    fruit2 apple
    fruit3 strawberry
    fruit4 grapes
    fruit5 melon
    fruit6 banana
    fruit1 apple
    fruit2 melon
    fruit3 banana
    fruit4 strawberry
    fruit5 apple
    fruit6 grapes
    fruit1 banana
    fruit2 apple
    fruit3 peaches
    fruit4 grapes
    fruit5 watermelon
    fruit6 apple

    Basically i want a loop that can copy the data vertically and then pasting it in Sheet2 horizontally.

    This is my desired result in Sheet2.

    etc1 etc2 fruit1 fruit2 fruit33 fruit4 fruit5 fruit6
    pears apple strawberry grapes melon banana
    apple melon banana strawberry apple grapes
    banana apple peaches grapes watermelon apple

    Thanks in advance!

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Europe, Croatia
    Excel Version
    Excel 2013
    Quote Originally Posted by newbie_vba View Post
    This is my desired result in Sheet2.
    I've tried to solve your problem
    On Sheet1 solution is 1,
    On Sheet2 is the solution 2
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts