If column E (customer Name) contains the word "Forecast", then zero out value in column M (gross margin).
Data range will varies every day, row 4 is header, data value will be from row 5 to around row 3000. (size changes every day, but 3000 rows will probably cover them all).
Please help. And thank you in advance.
Data range will varies every day, row 4 is header, data value will be from row 5 to around row 3000. (size changes every day, but 3000 rows will probably cover them all).
Please help. And thank you in advance.