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).
[TABLE="width: 1085"]
<colgroup><col><col><col span="2"><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD] Vehicle Reg [/TD]
[TD] Amount £ [/TD]
[TD] Invoice Date [/TD]
[TD] PMT Date [/TD]
[TD]Amount PAID[/TD]
[TD]Balance remaining[/TD]
[TD] Days outstanding [/TD]
[TD] Overdue [/TD]
[TD]PMT TYPE[/TD]
[TD] PMT Day [/TD]
[/TR]
[TR]
[TD]AB12CDF[/TD]
[TD] £ 1.00
[/TD]
[TD]15/03/2018
[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]£1.00[/TD]
[TD] 42[/TD]
[TD] yes [/TD]
[TD]Blank[/TD]
[TD] Monday [/TD]
[/TR]
</tbody>[/TABLE]
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).
[TABLE="width: 1085"]
<colgroup><col><col><col span="2"><col><col><col span="2"><col><col></colgroup><tbody>[TR]
[TD] Vehicle Reg [/TD]
[TD] Amount £ [/TD]
[TD] Invoice Date [/TD]
[TD] PMT Date [/TD]
[TD]Amount PAID[/TD]
[TD]Balance remaining[/TD]
[TD] Days outstanding [/TD]
[TD] Overdue [/TD]
[TD]PMT TYPE[/TD]
[TD] PMT Day [/TD]
[/TR]
[TR]
[TD]AB12CDF[/TD]
[TD] £ 1.00
[/TD]
[TD]15/03/2018
[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]£1.00[/TD]
[TD] 42[/TD]
[TD] yes [/TD]
[TD]Blank[/TD]
[TD] Monday [/TD]
[/TR]
</tbody>[/TABLE]
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