Sort Problem

  • Thread starter Thread starter Wayne Burritt
  • Start date Start date
W

Wayne Burritt

Hi: I have a row of column labels on row 4 and I'd like to be able to
program a macro that sorts based on the column labels. I have a row labeled
"other" on row 5 and row 92 -- these rows help anchor my ranges that I use
calculations with, so they can't be deleted. In between are rows of data
that I'd like to sort based on the column labels in row 4. I am always
adding and subtracting rows of data. Right now I have to manually select
the row right below "other" (row 6) and right above "other" (row 91), then
manually use the sort function. What I'd like to be able to do is for excel
to automatically select the row the data range (row 6 to 91 now) and then
sort. anyideas? thx Wayne
 
Hi Wayne,
One way. Highlight the range that you want to sort and
define a name. In the future F5 and select the name then
sort. Deleting rows is no problem. Make sure when you add
rows it is included in the range. You can always record a
macro to go to the range and sort.
ray
 
Back
Top