Sorting over Outlines

[RD Wirr]

I have a spreadsheet with a long list of data that I have
broken up into outline sections of 50 rows vertically to
make it easier to navigate up and down rather than
scrolling down through a long list. I have to sort this
list periodically by date and so I have recorded a VB
macro to expand the oultlines, selected the data
contained in range a dynamically set vertically and then
sort by the date column (K6). My problem is that only the
data that is above the first outline is sorted. Is there
any prohibition against sorting over an outline. If so,
does anyone have an idea about how to roll up the list
into manageable chunks and still have sorting capability?

Thanks in advance,
RDW

 

[Tom Ogilvy]

an obvious solution would be to make a macro that removes your outline,
sorts the data, reapplies the outline.

 

[RD Wirr]

That would work for me. Can you give me a hint as to
which way to go about building such a macro?

Rgds,
RDW

 

[Dave Peterson]

I'd start by:

tools|macro|record new macro

When you did it manually once.

Post back if you have trouble generalizing the code.