Alphabetical sort but includes the expanded section when it rearra

C

CG

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.
 
C

Chip Pearson

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem sorting a range of columns using VBA 1
Custom sort in macro disappears 3
sort alphabetical in report 4
Sort on 3 columns when number of rows vary daily 1
Sort Order Doesn't Seem Correct 5
Large Dynamic Named Range Sort Problem 3
Sorting a List Box 2
Sort report by sum of counts 4

Top