Good morning, everyone.
I need a For Loop to perform the following task. I tried but could not figure out.
Let’s say in range E8:F5000, if two consecutive cells in column E are empty and tow consecutive cells in column F are number, then in column A, the first corresponding cell will be given text value: Expense Code Total, the second corresponding cell will be given text value: Vendor Totals.
Any ideas will be highly appreciated.
Dennis