Help with multi-formatting of a workbook

Hello,

I am trying to wrap my head around macros still. I have used the recorder and have gotten some good results but I am coming to a part where I need some help.

I have a workbook with three spreedsheets. The first spreedsheet has a column range of A-AS. The rows can be anywhere from 4 to 4000. I need a macro to do several steps which I will try to outline by the steps I would need and in the order in which I would need to do them.

1. I would need to delete several columns (A-C, G-H, M-AB, AE-AK)
2. I would need to copy and paste any negative numbers (rows) from column (O) to a new tab called "Credits"
3. I would need to delete any rows that were copied to the "Credits" tab
4. I would then need to custom sort the spreedsheet with three levels- Column C, Column A, Column J
5. I would then need to clear the numerical content of Column (O)- adding a new header as "Quantity"
6. I would then need to add two blank rows between every different product in Column C

I have attached a copy of the raw data so you can see what I am working with, Plus a copy of what I need the spreedsheet to look like after I apply the macro.

Any help would be very much appreciated

Hi MikeTRON thank you so much for responding, I in fact did upload an incorrect file. I apologize. I have uploaded a more complete worksheet and took your advice. The book has three sheets, the first sheet is the manipulated raw data, the second is the credits (I would prefer the Macro automatically creates the new tab) and the last tab is how I would like the finish product to look like when all negatives have been removed and the sheet has been re-organized. I hope the new samples will clear up what I am trying to achieve. Again thank you so much for your time. The name of the sheet MDDataExtract is how the file will be named in the end if that helps.

Hi again MikeTRON

The credits tab does not exist- I would like the code to make a new tab called Credits so that it can move the negative rows from column O to it. After all negative rows have been moved over to the newly created credits tab, I would then like the negative rows from the original spreadsheet "MDDataExtract" to be deleted, only leaving the positive numbers.