Recent content by chteoh

Yes it did work as per my requirement. Thank you so much Mr Aniruddah.

Hi all, I managed to find the coding in the website for split the excel file into multiple files but fix to column A only. Now I am lacking of auto save with correct filename and populate the email standard note with correct email subject based on filename. Will keep the team updated if there is...

Hi Mr Aniruddah, Thanks so much for your reply. I am sorry being late reply. I hope to elaborate more on my request. Below is my example of raw data for PO and the actual row can be >10K PO with >2K of different vendor ID. Inventory ID Vendor ID Email address PO No Quantity D0001-01-01...

Good day to everyone. I am not very familiar with VPA and learn the coding by record Macro and online comment. I have one request for solution using VBA to split the file into multiple excel files based on specific column( i hope that can be variable based on user setting) and sending out the...