CALLISTAJM
New Member
- Joined
- Jun 12, 2017
- Messages
- 11
Hi Guys,
I'm looking for a macro that if the 'PMT Day' is Monday and the invoice date is today or earlier - will put that line onto another sheet with the tab name (Clients name).
<colgroup><col><col><col span="2"><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
I don't know how to edit macros but I did get a simular one off here before that I used, and I have tried to edit it with zero luck So any help will be greatly appreciated
Thanks in Advance,
Rose x
I'm looking for a macro that if the 'PMT Day' is Monday and the invoice date is today or earlier - will put that line onto another sheet with the tab name (Clients name).
Vehicle Reg | Amount £ | Invoice Date | PMT Date | Amount PAID | Balance remaining | Days outstanding | Overdue | PMT TYPE | PMT Day |
AB12CDF | £ 1.00 | 15/03/2018 | £1.00 | 42 | yes | Blank | Monday |
<colgroup><col><col><col span="2"><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>
I don't know how to edit macros but I did get a simular one off here before that I used, and I have tried to edit it with zero luck So any help will be greatly appreciated
Thanks in Advance,
Rose x