Table to Array and Sorting

[atakanyy]

Hi,

I have a table contains a lot of data (such as 20 x 30 dimension).
I want to turn this table to array and sorting array (small to big) for first column of table. After that, paste array as table to another sheet .
How can ı write codes?

Thanks...

[gjcase]

atakanyy:

It may be easier to just do the sort in the table, and then do a copy/paste. Those are easy in VBA, you could probably use the recorder to get you started.

[atakanyy]

atakanyy:

It may be easier to just do the sort in the table, and then do a copy/paste. Those are easy in VBA, you could probably use the recorder to get you started.

Copy/paste run it slowly. I want to execute as fast as possible.

[atakanyy]

Topic up...

[torachan]

See big yellow banner - how to upload your workbook.
Far easier to give targeted help using physical workbook - shortcuts a lot of questions and 'crystal ball gazing'.
torachan.

[Marc L]

Hi,

I have a table contains a lot of data (such as 20 x 30 dimension).
I want to turn this table to array and sorting array (small to big) for first column of table. After that, paste array as table to another sheet .
How can ı write codes?

Thanks...

Hi,

for such small data no need array as Copy & Sort Excel features are fast enough !

Just activating the Macro Recorder and operating manually like any Excel beginner can operate
you can get your own VBA code base …