Macro to sort data in spreadsheet but maintain empty rows between data.

Hello.

The solution to this might be very simple, but it escapes me. I have a spreadsheet where I want to sort data across the entire spreadsheet according to the value in column A. The problem is that between rows of data I have blank rows and I need to keep it that way.

When I sort with excel it will sort the column perfectly but it will move the blanks to the very bottom of the column and I need them between the rows of data.

What would be the best solution for this? Should I do a sort and then have a macro put a space between the rows that have a different value in column A or is there a better way?

The spreadsheet could look like this:

COLUMN A:

ZZ091
ZZ091
ZZ091
Blank row
XX189
Blank row
ZZ092
Blank row
XX190
XX190
Blank row
XX191
XX191

After running the macro I want it to become:

XX189
Blank row
XX190
XX190
Blank row
XX191
XX191
Blank row
ZZ091
ZZ091
ZZ091
Blank row
ZZ092

Please let me know if the question is not clear and I will try to clarify what I am trying to do. Thanks for your help.

Hello snb,

Thank you very much for the post. Sorry about the late reply.

I tried running this code but it does not seem to do anything. Is there anything special that I need to do to make it work?

Hello.

Thanks for the reply. I do not think I explained what I am trying to do very well.

Here is an excel file with an example of what I am trying to sort and a second tab with an example of what I want the data to look like after the sort.

Hi, I have been working on this but have made no progress. If anyone has any ideas it would be great. I have been trying to modify venkat1926's code, but have not gotten anywhere.

Thanks for the help everyone, sorry about not explaining this situations very well.

I am guessing that this is harder to do than I expected. I have still not figured it out. I'll try to avoid having to do this instead. I am not sure how to close a thread but if any admin sees it they can feel free to close this.

Thanks again.

Try

Please Login or Register  to view this content.

Thanks so much jindon

This is exactly what I was trying to do. Works perfectly!

I have a question very similar to this case.

Original Raw Data Set Consists of 3 different product types followed by a unique number
Product types are ZB, ZR and ZC
Column A = Sales Number
Column B = Profit

Column A:
ZB12221
ZB12231
ZR12241
ZB12251
ZR12261
ZC12271
ZB12281

Column B:
$5
$6
$4
$5


End Result Goal"
ZB12221
ZB12231
ZB12251
SPACE // SUM OF PROFIT
ZR12241
ZR12261
SPACE // SUM OF PROFIT
ZC12271
SPACE // SUM OF PROFIT

Sort; space between differing product types and sum the column B values.

Any answers out there?

maxutility,

Hi-jacking someone else' thread is against the rule here.

Open a new thread for your own and link to this thread.
You will probably be asked to upload a sample workbook to work with.