When you say add Stores_To_Ignore. Will that remove the complete row with that store?

There are a couple added fields I need to depend on other factors. You should be able to see these from my macros in the xlsm files I provided.
Ex
Column J on the converted files has whats called a class. The class all depends on the type of customer it is. All Chains stores "The customer name will start with a 1 "ex 1Hannaford:Ha367 Albany" has a class of "1 sales". The line from the macro "AddClassAll" shows them
"=IF(LEFT(RC[-7],1)=""1"",""1 Sales"",IF(LEFT(RC[-7],1)=""2"",""6 Institutional"",IF(LEFT(RC[-7],1)=""3"",""5 Rest"",IF(LEFT(RC[-7],1)=""4"",""1 Sales"", """"))))"
Then for the credits all the class is "2 Returns"
When there is a discount it has a field called line class. The midstate conversion files has a discount macro. For discounts they have a column called "line class". This is shown in the midstate invoices converted.xlsx file.
There is also a column "K" called template. The temple is determined by the class. If the class is 1 Returns the template is "Copy of:Intuit Service Invoice" If the class is a 2 returns the template is Custom Credit Memo

The invoice conversion xlsm file MidstateInvoice.xlsm has the discount macro. Not all of the xlsm have the discount macro.
Another factor to consider is if the qty column has a 0 the row will need to be removed. Not all the xlsm files have the macro ZeroRemoveH. Some of the raw data does not include 0 in the qty column. When there is a 0 in qty column that row needs to be removed.

You can see how these fields are all created and what I need by looking at all the macros. Would you also like me to explain how the macros all work in detail or are you looking at the macros and they can show what is needed?

Again I appreciate all the work you are doing and helping me to create these tools.

Thanks