Hello...
I have a list of customer with name and billing amount that I need to copy to another sheet (receipt).
This receipt is then need to be saved under customer's name in PDF (as I need to send it by email later on).
The customer list changes every day.
In the request column, I will only filter those with Invoice request and make the receipt.
It's very tedious work to make it one by one every day, so if anyone can help me with the macro code that'd a great help for me.
I'm very bad with macro and can only make basic one.
Any help is appreciated.
Thank you in advance
I have a list of customer with name and billing amount that I need to copy to another sheet (receipt).
This receipt is then need to be saved under customer's name in PDF (as I need to send it by email later on).
The customer list changes every day.
In the request column, I will only filter those with Invoice request and make the receipt.
It's very tedious work to make it one by one every day, so if anyone can help me with the macro code that'd a great help for me.
I'm very bad with macro and can only make basic one.
Any help is appreciated.
Thank you in advance
