Alphabetical sort but includes the expanded section when it rearra
 

How do you get a database to alphabetically sort (VBA) by say the first row
(last names) but then when it sorts and uses the expanded area. So that the
rest of your data rearranges also.


--
CG

Alphabetical sort but includes the expanded section when it rearra
 

Select the entire region that is to be sorted (all columns, not just
the last name column) and then sort, specifying the last name column
as the key.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sun, 23 Nov 2008 08:20:03 -0800, CG
wrote:

How do you get a database to alphabetically sort (VBA) by say the first row
(last names) but then when it sorts and uses the expanded area. So that the
rest of your data rearranges also.