I had the code working now it change to bring a date that does not exist in the book it is calling from. The box is EMPTY. Was working. But add to my Macro no brings a date that is not to be there. The cell above is set to if cell is ="" the says unpaid. Now since it is bringing invaild information to it shows as paid.
Any Help would be greatly appreciative
Funny thing is i spent days working on find code to help with macro taking bits here and there. now i have it working and not this lol.
Any Help would be greatly appreciative
Funny thing is i spent days working on find code to help with macro taking bits here and there. now i have it working and not this lol.
| East Cameron Township - Copy.xlsm | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 32 | COUNTY/LOCAL 2021 | 3/1-4/30 | 5/1-6/30 | 7/1-12/31 | |||
| 33 | Discount (-2%) | Face: | Penalty (+10%) | ||||
| 34 | PAID | $498.86 | $509.04 | $559.95 | |||
| 35 | Date Paid: | 1/0/1900 | Assessed Value: | 12,300 | |||
| 36 | |||||||
| 37 | |||||||
| 38 | SCHOOL 2021 | July/Aug | Sept/Oct | Nov/Dec | |||
| 39 | Discount (-2%) | Face: | Penalty (+10%) | ||||
| 40 | PAID | $435.39 | $444.28 | $488.71 | |||
| 41 | Date Paid: | 12/28/2021 | Assessed Value: | 12,300 | |||
Tax Cert Form 2022-2021 | |||||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| C34 | C34 | =INDEX('C:\Users\pmill\Google Drive\2021\[2021 - ECT - Real Estate.xls]Real Estate'!$A$1:$P$65536,MATCH(C12,'C:\Users\pmill\Google Drive\2021\[2021 - ECT - Real Estate.xls]Real Estate'!$L$1:$L$65536,0),8) |
| D34 | D34 | =INDEX('C:\Users\pmill\Google Drive\2021\[2021 - ECT - Real Estate.xls]Real Estate'!$A$1:$P$65536,MATCH(C12,'C:\Users\pmill\Google Drive\2021\[2021 - ECT - Real Estate.xls]Real Estate'!$L$1:$L$65536,0),9) |
| B34,B40 | B34 | =IF(B35="", "UNPAID", "PAID") |
| B35 | B35 | =INDEX('C:\Users\pmill\Google Drive\2021\[2021 - ECT - Real Estate.xls]Real Estate'!$A$1:$P$65536,MATCH(C12,'C:\Users\pmill\Google Drive\2021\[2021 - ECT - Real Estate.xls]Real Estate'!$L$1:$L$65536,0),3) |
| E34 | E34 | =INDEX('C:\Users\pmill\Google Drive\2021\[2021 - ECT - Real Estate.xls]Real Estate'!$A$1:$P$65536,MATCH(C12,'C:\Users\pmill\Google Drive\2021\[2021 - ECT - Real Estate.xls]Real Estate'!$L$1:$L$65536,0),10) |
| E35 | E35 | =INDEX('C:\Users\pmill\Google Drive\2021\[2021 - ECT - Real Estate.xls]Real Estate'!$A$1:$P$65536,MATCH(C12,'C:\Users\pmill\Google Drive\2021\[2021 - ECT - Real Estate.xls]Real Estate'!$L$1:$L$65536,0),11) |
| C40 | C40 | =INDEX('C:\Users\pmill\Google Drive\2021\[2021 - School - Real Estate.xls]Real Estate'!$A$1:$O$65536,MATCH(C12,'C:\Users\pmill\Google Drive\2021\[2021 - School - Real Estate.xls]Real Estate'!$O$1:$O$65536,0),8) |
| D40 | D40 | =INDEX('C:\Users\pmill\Google Drive\2021\[2021 - School - Real Estate.xls]Real Estate'!$A$1:$O$65536,MATCH(C12,'C:\Users\pmill\Google Drive\2021\[2021 - School - Real Estate.xls]Real Estate'!$O$1:$O$65536,0),9) |
| B41 | B41 | =INDEX('C:\Users\pmill\Google Drive\2021\[2021 - School - Real Estate.xls]Real Estate'!$A$1:$O$65536,MATCH(C12,'C:\Users\pmill\Google Drive\2021\[2021 - School - Real Estate.xls]Real Estate'!$O$1:$O$65536,0),3) |
| E40 | E40 | =INDEX('C:\Users\pmill\Google Drive\2021\[2021 - School - Real Estate.xls]Real Estate'!$A$1:$O$65536,MATCH(C12,'C:\Users\pmill\Google Drive\2021\[2021 - School - Real Estate.xls]Real Estate'!$O$1:$O$65536,0),10) |
| E41 | E41 | =INDEX('C:\Users\pmill\Google Drive\2021\[2021 - School - Real Estate.xls]Real Estate'!$A$1:$O$65536,MATCH(C12,'C:\Users\pmill\Google Drive\2021\[2021 - School - Real Estate.xls]Real Estate'!$O$1:$O$65536,0),14) |
