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 Name fruit1 pears fruit2 apple fruit3 strawberry fruit4 grapes fruit5 melon fruit6 banana Name fruit1 apple fruit2 melon fruit3 banana fruit4 strawberry fruit5 apple fruit6 grapes Name 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!
I've tried to solve your problemOriginally Posted by newbie_vba
On Sheet1 solution is 1,
On Sheet2 is the solution 2
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
Reply With Quote
Bookmarks