macro to sort and delete certain rows?

Hello,

I'm fairly new to excel but have become pretty well versed in the basic functions.

Have never done much with macros though.

I've got a sheet of data for all orders placed throughout a month, who sold them, and what type they were (more data fields but these are all I'm really concerned with).

I've been manually sorting the data, removing all types of sales that we don't need (Type 4) and then doing a "count if" to determine how many of each product was sold.

Am going to be looking at a lot more data and am trying to build a macro that will sort the raw data, delete all the type 4 orders, then do the count if functions and set up charts etc. I'm pretty sure I can record the functions and charts but my concern is how do I get the macro to delete all of that type of order. Then, how do I account for different numbers of orders each month? Ie - if we have 600 orders next month instead of 500, how can I set the count if's etc to count until an empty cell rather than just count a set range. Thanks for any advice!

What column are you sorting by? What column is the type in? Does the type say just 4 or Type 4?

to delete the 4's I've been just sorting them by type, highlighting all the 4's and deleting them manually. then using counta/countif to get some stats out of the data.

they just say "4"

thanks!

Originally Posted by gtiguy

to delete the 4's I've been just sorting them by type, highlighting all the 4's and deleting them manually. then using counta/countif to get some stats out of the data.

they just say "4"

thanks!

That didn't address my first two questions. I need that for the code.

I'm sorting by type only because I've been manually deleting them. Ideally I would like to find a way to take all the various salesperson numbers and have them split onto seperate tabs. Other than to delete the "4" type of work order I don't really need to sort have been just counting data. The "4" is type which is column b, order number is a and salesperson is d. Thanks, does that help?

Please Login or Register  to view this content.

Awesome, this worked perfectly, thanks for your help!

One final piece, looking to split the resuts from one master sheet into individual tabs. Was sorting column e (employee id) and manually removing each group of rows into a new tab with the id as the tab name. Any ideas on if a macro can accomplish this?

Also, any good books or online courses you would recommend? I'd like to learn more about editing this code so I don't have to bother the forum with every task I need to complete thanks

This is untested, but you can use the same technique to do this

Please Login or Register  to view this content.

The best book is the book of experience (I can't believe I wrote that corny tripe!). Seriously, books can help, but it is just doing and practicing that hones the skills.

Thanks again...

Getting a few errors with this one that I'm not sure where to start troubleshooting.

The first is "expected end sub". This goes away when I delete the public sub copydata line and replace with my own name for the macro.

At "copybytype" I get a sub or function not defined compile error. Beyond that I get a syntax error as I start playing around.

Any tips on where to start? Thanks again!

none of those errors make any sense as far as I can see.