Hi, my name is Michael.
I need your help and guidance for solving the problems I have encountered.
Suppose, I have a data from book1 attach on a picture in this forum.
There are issued date, distributor, order no, and shipment.
What I have to do is: requesting the PC No to the distributor when the date shows: the issued date + 14 days --> Let's called it by the "DUE DATE"
For example, Issued date = 8th January 2022, + 14 days, then the DUE DATE is is 22th January 2022 --> I have to request the PC no to the distributor.
And so on for another issued date and due date.
The problem is, there will be a lot issued date data in the real simulation.
For solving that problem, I have an idea to make a click button called "Request PC No". What I want is when I click that button on book1, then the excel transfers the data automatically to the book2 based on the due date using the VBA.
However, I don't really familiar with the VBA code.
Can anyone help me?
Thank you.
Best regards,
Michael.
I need your help and guidance for solving the problems I have encountered.
Suppose, I have a data from book1 attach on a picture in this forum.
There are issued date, distributor, order no, and shipment.
What I have to do is: requesting the PC No to the distributor when the date shows: the issued date + 14 days --> Let's called it by the "DUE DATE"
For example, Issued date = 8th January 2022, + 14 days, then the DUE DATE is is 22th January 2022 --> I have to request the PC no to the distributor.
And so on for another issued date and due date.
The problem is, there will be a lot issued date data in the real simulation.
For solving that problem, I have an idea to make a click button called "Request PC No". What I want is when I click that button on book1, then the excel transfers the data automatically to the book2 based on the due date using the VBA.
However, I don't really familiar with the VBA code.
Can anyone help me?
Thank you.
Best regards,
Michael.