I am needing a macro to clear row content in Column A:J based on multiple criteria. I have attached excel file with the data and desired result.
Criteria
1. EFF DATE COLUMN - Clear Contents of A:J row that are less than today @ 17:45. Note eff.Date is imported data does not contain correct eff time. The time is found in the Eff.Time Column. I need to clear content of old prices that are in the past.
2. GROSS PRICE COLUMN-Clear Contents of A:J row that are less than 5.
3. OUTAGE COLUMN-Clear Contents of A:J row that are equal to Y
Problems
Can Not CLEAR Data IN Columns K:M because they contain formulas
Data only needs to be cleared in Column A:J
Any help would be appreciated.
Thank you!
[TABLE="width: 234"]
[ATTACH=CONFIG]67280[/ATTACH]
[/td][/tr]
[/TABLE]