Sorting when the rows are never the same

[Guest]

I'm Using Excel 97. I have a daily report in which the colums are always the
same A-I. The sort will always start with cell A4, sorts by column D and then
by Column G in Ascending order, no header row. The problem is that the rows
which contain the data will never be the same. example: a4.I15 or A4.I30 This
is a daily report so the data changes daily the rows will never be the same.
I cannot record a macro my steps manually because the data rows are never the
same. Does anyone have a way to do this?.

 

[Frank Kabel]

Hi
why not make the data range large enough. e.g. sort A4:I500

 

[Guest]

That would be to easy. In this report I have different product data, for
example the first row A3 is for one specific product, the second product
appears after the last row of the first product, for example

the first product appears in cell A3 "non real estate" then after the last
row of "non real estate" lets say A15, the second product is listed in row
A16 "Real Estate" so I can only sort by the specific range A4.I15. I hope I
explain this correctly, If i did do you have any suggestions.

 

[Frank Kabel]

Hi
why not sort first for the product name and then for your other key?

 

[Guest]

Frank, I'm not explaining my problem correctly. I want a macro to sort a
specific range "A1.I15",(will always vary). My problem is that since it's a
daily report the rows will never be the same. Certain days I may have 10
applications other days I may have 3 applications. What I want the macro to
do is sort the first product "Non Real estate " "A1.I15"(will always vary)
The sort will always start with cell A4, sorts by column D and then by
Column G in Ascending order, no header row. The sort will end 1 row above
product "Real Estate". I tried to record a macrobut since the rows are never
the same the macro does not work properly. Do you want to see the macro?