re-arrange column and rows?
I have a workbook which has two column like that:
A..............B
Chiris........10
Chiris........20
Chiris........40
Chiris .......50
Chiris .......30
Lui............10
Lui............30
Lui............40
Lui............80
I want to re-arrange this data in a new sheet (not an existing one) like that in two column:
A...........B
Chiris ....10, 20, 40, 50, 30
Lui.........10, 30, 40, 80
Data has more than 10.000 rows and many different names. Is there any way to make this with a macro ?
Thanks..
Try this code
Copy the Excel VBA code
Please Login or Register to view this content.
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste
To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button
Last edited by arlu1201; 12-06-2012 at 03:07 PM.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
See attached
Last edited by AB33; 12-06-2012 at 01:42 PM.
Thanks arlu1201 your code is worked fine, but there must be a sheet called "sheet2" in workbook in order to run this macro. is there any way to see results in a new created sheet?
And AB33; i think this code is what i need but it did not worked
screen.jpg
I have edited the code.
Thanks arlu1201 it worked.. this is fantastic..)
Last edited by qokalp; 12-06-2012 at 03:30 PM.
You need to install Ms run time script in your module.
Go to Module- tools-Refrence- Go down to the middle of the list and choose(Tick) Ms run time script. Do no run- first time, just save and close it.
When you re-open and try to step over and see if you get this error. If you get the error, that can only be you have not installed it properly. Try it again. The code works as you can see from the result. Let me know.
Thanks for your replay, but i can't find "Ms runtime script" on the list. maybe, my excel does not support or is there any other name. I'm using Ms Excel for Mac 2011..
screen2.jpg
Hmm!
Okay. I now know the problem. Your version of excel does not show that you have Mac. With out going deep in the teki side of VBA. There are two types of script. Early and late binding. I will try to adjust the code (tom) if it works on late binding(There is not gurantee) and see how it goes. So back tomorrow.
i see
Please attached. I have added two more codes and finger crossed, one of them may appeal to Mac
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks