macro to generate sorted table from unsorted list?

**JGCA** · 10-17-2008, 12:46 PM

on worksheet 1, I have 100 unsorted rows with:

First Name | Last Name | Phone Number

I would like to have this formatted on worksheet 2 with a specified (via a variable) number of rows and columns in alphabetical order by FirstName LastName | Phone Number.

So the output would be something like:

NAME | PHONE | NAME | PHONE | NAME | PHONE --> through column break
Abe Smith | 12345
Adam Johnson | 12346
...
...
...
through row break.

So in above example, columns would be 6 (NAME|PHONE|NAME|PHONE|NAME|PHONE) and rows might be 36.

The First 2 columns might have data for names starting with A-F, the next might have data for G-J, depending of course on the names in the original unsorted list of worksheet 1.

Can someone help me with this?

**JGCA** · 10-20-2008, 01:29 PM

Any ideas here?

**shg** · 10-20-2008, 01:36 PM

It would be easier to help if you posted a workbook with a useful amount of data and the start of expected results.

BTW, why not just sort the data on the first worksheet?

**JGCA** · 01-20-2009, 03:09 PM

I have attached an example worksheet...

Could someone take a look?

**JGCA** · 05-14-2009, 10:51 AM

Does anyone have an idea how I can do this?

**Phil_V** · 05-14-2009, 10:56 AM

Why are you wanting to constrain both the number of rows, and the number of columns in your generated table?
It would be normal to say it can be 6 columns, and however many rows it needs, or to say it can be 36 rows, and how ever many columns it needs, but by wanting to specify both you could cause your self problems.
For instance imagine you have 100 records, and you specify that your table can be 6 columns by 5 rows.... that will only allow space for 15 entries, what happens to the ones you didn't allow to fit?

Incidently, as above, why don't you just sort the original list?

**Phil_V** · 05-14-2009, 11:14 AM

I'm looking at this for you at the moment, but the data in your example spreadsheet is not formatted the same as you suggested in your original post. I shall code based on the example spreadsheet and then you can change it if neccasary

**Phil_V** · 05-14-2009, 11:36 AM

See if the attached satifies your needs.
It only allows you to specify the number of columns as it makes little sense to specify rows as well.
The output is generated on the "Output" worksheet.
Run the macro by running "Generate_It"

macro to generate sorted table from unsorted list?

LinkBack

Thread Tools

Rate This Thread

Display

macro to generate sorted table from unsorted list?

Re: macro to generate sorted table from unsorted list?

Re: macro to generate sorted table from unsorted list?

Re: macro to generate sorted table from unsorted list?

Re: macro to generate sorted table from unsorted list?

Thread Information

Users Browsing this Thread

Similar Threads

A macro to cut data from one table and paste it onto another worksheet

Macro for copy/insert into expanding table

Pivot Table List refreshing problem

Use Macro to add data to end of a list

Need a macro to search and remake any list

Bookmarks

Bookmarks

Posting Permissions