NCL_AP STATEMENT1.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
15 | INVOICE DATE | INVOICE # | INVOICE DUE DATE | A/C | AMOUNT$ INVOICE/PAYMENT/ ADJUSTMENT | REF/ CHQ. # | BALANCE | REMARKS | |||
16 | Balance brought forward | ||||||||||
17 | 12/17/2020 | CA1000100498 | 01/16/2021 | 339.00 | 339.00 | ||||||
18 | 12/17/2020 | CA1000100499 | 01/16/2021 | 840.15 | 1,179.15 | ||||||
19 | 12/17/2020 | CA1000100500 | 01/16/2021 | 7,775.15 | 8,954.30 | ||||||
20 | 01/14/2021 | PY00000000000000004546 | (8,954.30) | 0.00 | |||||||
21 | |||||||||||
22 | |||||||||||
23 | |||||||||||
24 | |||||||||||
25 | |||||||||||
26 | |||||||||||
27 | |||||||||||
28 | |||||||||||
29 | |||||||||||
30 | |||||||||||
31 | |||||||||||
STATEMENT |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H17:H20 | H17 | =IF(AND(ISBLANK(E17)),"",H16+E17) |
NCL_AP STATEMENT1.xlsx | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
15 | INVOICE DATE | INVOICE # | INVOICE DUE DATE | A/C | AMOUNT$ INVOICE/PAYMENT/ ADJUSTMENT | REF/ CHQ. # | BALANCE | REMARKS | |||
16 | Balance brought forward | ||||||||||
17 | 12/17/2020 | CA1000100498 | 01/16/2021 | 339.00 | 339.00 | ||||||
18 | 12/17/2020 | CA1000100499 | 01/16/2021 | 840.15 | 1,179.15 | ||||||
19 | 12/17/2020 | CA1000100500 | 01/16/2021 | 7,775.15 | 8,954.30 | ||||||
20 | 01/14/2021 | PY00000000000000004546 | (8,954.30) | 0.00 | |||||||
21 | |||||||||||
22 | |||||||||||
23 | |||||||||||
24 | |||||||||||
25 | |||||||||||
26 | |||||||||||
27 | |||||||||||
28 | |||||||||||
29 | |||||||||||
30 | |||||||||||
31 | |||||||||||
STATEMENT |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H17:H20 | H17 | =IF(AND(ISBLANK(E17)),"",H16+E17) |
There are no rows in that sample that I can see that meet the requirement you originally stated:Sample here:
How can delete blank rows from a range that contains formulas but have no value
Confused me tooThere are no rows in that sample that I can see that meet the requirement you originally stated:
What row(s) do you want deleted from that sample and why?
Range(Cells(Rows.Count, "A").End(xlUp).Offset(1), Cells(Rows.Count, "H").End(xlUp)).EntireRow.Delete
Perhaps you missed post #10?If I understand your setup correctly, this single line of code should delete the rows you want to delete...
VBA Code:Range(Cells(Rows.Count, "A").End(xlUp).Offset(1), Cells(Rows.Count, "H").End(xlUp)).EntireRow.Delete