Seems to be working great.
Thanks
Two other questions if you have time.
1) Can you also have it remove KKB when it finds it. I have that used the same as the word STALE. So just deleting KKB would be great. I do need to make sure it only deletes KKB if it finds it in column C. There may be cases where KKB is in another column and that needs to stay.
row 44 in the attached file shows a store with KKB after it.
Also when there is no invoice on the same day it changes the identification number so the top item of the credit has a different invoice number. It leaves the top one and adds a 9 to the ones below it. Causing the credit to be split into two credit memos.
The first line is 1189 and then under that is 91189. That is because there was no invoice on that day. Can the code be adjusted so if it does not find an invoice on the same day to not make any changes to the credit number.
That is a cause does not happen often. When that does happen it is no assigned a rep. "Column L" I dont think there will be a way to give it a rep. I can deal with that. I just cant have the credit split into two.
The attached file shows the results where this happens after your code is ran. Starting on row 28 you will see what is happening.
12/24/2020 1189 Independent Stores:Northstar Orchards 21 CW 6 3 C 12/24/2020 91189 Independent Stores:Northstar Orchards 25 WW 2 3 C 12/24/2020 91189 Independent Stores:Northstar Orchards 26 FP 14 3 C 12/24/2020 91189 Independent Stores:Northstar Orchards 31 OAT 3 3 C 12/24/2020 91189 Independent Stores:Northstar Orchards 33 ITAL 8 2.25 C 12/24/2020 91189 Independent Stores:Northstar Orchards 34 JR 3 3 C 12/24/2020 91189 Independent Stores:Northstar Orchards 40 Flaxseed 2 3 C 12/24/2020 91189 Independent Stores:Northstar Orchards 45 Multi Grain 4 3 C 12/24/2020 91189 Independent Stores:Northstar Orchards 23 HR 1 3 C 12/24/2020 91189 Independent Stores:Northstar Orchards 22 RYE 2 3 C 12/24/2020 91189 Independent Stores:Northstar Orchards 28 WB 3 3 C
Reply With Quote