identification & deletion of rows

[Andrew Quirl]

Needing macro to do the following steps:
1. Identify (keep) certain rows by row # (i.e., rows 3, 4 and 7 for customer "X", rows 2,3 and 11 for customer "Y")
2. Identify (keep) certain rows if they include one of a list of possible values. (i.e., EA, BX, PAC, PC, Item Number, Part Number:, etc)
3. Delete rows that did not get identified.
4. Email the worksheet file to an email address.
5. Close the worksheet file.

The macro will be customized to each customer's data set:
City Corp -
Step 1 would identify rows 4, 5 and 13 to keep every time.
Step 2 would identify row 34 for the value "BOX" (stand-alone word, so the word "sandbox" on a row would not cause the row to get identified), row 36 for the value "Part No.:", row 38 for the value "BOX", and row 40 for the value "Part No.:"

Southern Corp -
Step 1 would identify rows 3, 10, and 13 to keep every time.
Step 2 would identify row 26 for the value "EACH", and row 28 for the value "CASE"

Denver Corp -
Step 1 would identify rows 1, 4 and 5 to keep every time.
Step 2 would identify rows 17, 19, 21, and 23 for the value "EA"

Once the macro is customized to a specific customer, it will be run on every data set sent in by that customer.

 

[Marc L]

At least do you start to code anything ?!​

 

[Andrew Quirl]

I spent a lot of time going back and forth with a guy on another site and we got this codebook attached here. The problem with this is that you have to run the codebook and fill out the userforms on every order placed by a customer. I need it to be more of a macro generator where I am setting up a customized macro for customers that will get run on all their incoming orders.