I'm trying to sort tables of data according to the name of the range the
tables cover. Each table is exactly the same size (i.e. B2:M15) and
each range is named according to the name of the employee the table
relates to (e.g.SmithJohn for John Smith).

Each table has has an empty row above and below it, i.e. the upper left
corner of the first table is in B2, the upper left corner of the second
table is in B16, then B30...etc.

How can I sort these tables into alphabetical order according to the
name of the ranges they cover?

I need to do this in vba and I should point out that I'm only a novice
user!


---
Message posted from http://www.ExcelForum.com/

I would insert an extra column to the left, so you data starts in C2 and
columns A and B are blank.

Next to each block (rows 2 to 15 for example) I would fill with the name of
the person and in column B I would put in a numerical sequence number.
Then I would sort all the data using column A as the first sort key and
column B as the second sort key.

--
Regards,
Tom Ogilvy

"cornishbloke" wrote in message
...
I'm trying to sort tables of data according to the name of the range the
tables cover. Each table is exactly the same size (i.e. B2:M15) and
each range is named according to the name of the employee the table
relates to (e.g.SmithJohn for John Smith).

Each table has has an empty row above and below it, i.e. the upper left
corner of the first table is in B2, the upper left corner of the second
table is in B16, then B30...etc.

How can I sort these tables into alphabetical order according to the
name of the ranges they cover?

I need to do this in vba and I should point out that I'm only a novice
user!


---
Message posted from http://www.ExcelForum.com/