What my my boss wants is for rows to auto fill when a tenant(s) pay rent on any given day and then to ignore days when no one pays.
For example: (All on the Ledger2 Tab)
Rows B33:AF57 is where the data will come from
What the boss wants is for an end result like in rows A62:A68 (Done Manually)
As you can see, Tenants paid rent on the 1st, not on the 2nd, then on the 3rd, 4th, 5th and 6th but these could be any tenant or tenants on any days.
He does not want a row dedicated to any day he only wants them to autofill when paid
Any help would be appreciated
Shawn
Bookmarks