Macro Needed to Sort Data in Columns

[823]

Hello,



I'm new in this forum

With your help I would need to create a macro that can do the request in the file xls I've attached below....

....with this macro I Need to sort Data in Columns....


Thank you


EXCEL MACRO VBA-1.xlsx

[mehmetcik]

I am sorry my friend.

No one will reply to your request for help.

You need to post three separate requests for help.

You need to change your title,

1. Macro Needed to Sort Data in Columns
2. Macro Needed to Concatenate Data in separate rows
3. Macro Needed to Concatenate Data in separate tables



Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[mehmetcik]

This Macro will do what you ask for the data that you posted.

I cannot create something for your real data without seeing it.

I need to know the start row number and the number of columns and rows

For now, open the attached file and click on the button.

Please Login or Register  to view this content.

[823]

This Macro will do what you ask for the data that you posted.

I cannot create something for your real data without seeing it.

I need to know the start row number and the number of columns and rows

For now, open the attached file and click on the button.

This is simply PERFECT what I need.

If I have toher type of data I have just to modyfy this colored in red:

Please Login or Register  to view this content.

Thank you very much Mehmetcik!!!

[mehmetcik]

We can do a lot more than that.

We have formulae that can count the number of rows and columns.

So we can make it automatic.

But we need to know where the data is before we can do that.

[823]

Hello,


Please, I need a simple macro that do exactly what I explained in the file attached at this post.



Thank you very much for help!



EDIT: SEE MY POST BELOW

[mehmetcik]

What row are your readings in sheet 1 and sheet 2

[823]

If you mean "title row / columns name" they always start on A1, both on sheet1 and sheet2.
On sheet 1 It can be a large amount of data (more than 30000 rows)


I need a simple macro that do this:

-Read the "sequence of column's title" present on sheet 2. (start from A1)
-Copy those columns -and all the data contained- from sheet1 to sheet 2 with the exact order present on sheet 2


that's all!


Please see file attached updated.


Thanks!

[jindon]

Only for your uploaded data.

Please Login or Register  to view this content.

[823]

.............I need that it put the result direct in sheet 2...



Someone can code it?



thank you

[jindon]

You should have uploaded the latest file in the first place.
Remember, nobody want to write a serious code with the lazy formatted data structure.

Please Login or Register  to view this content.

[823]

....I make a bit of confusion with my new request on this thread.
It is better to divide it.

http://www.excelforum.com/excel-programming-vba-macros/1066834-macro-needed-to-copy-data-from-sheet1-to-sheet2.html#post3989957