Hello all,
I've run across a challenge whereby I'm 'wasting' time very day and I think it is something that I should be able to program in VBA.
Unfortunately I have not yet been able to find out how, so here comes my request to you.
I need the source data to be copied over from by source file to an external file per unique order number, email that external file, and then start with the next order number, and cycle through the document until all orders are done.
source document = "data.xlsx"
external document = "template 1.xlsx"
1. Column A of the source document contains the order number (this could be 1 lines, but could also be 10 lines with the same order reference number)
2. Data from column B-C (basically the content of each order) of that source document needs to be copied over to cell A1 external document. (let call this "template 1.xlsx").
The number of lines to be copied over from B-C is equal to the amount of lines that have the same order reference as column A
3. After data is copied over, "template 1.xlsx" is to be saved with the order reference number from Column A
4. VBA needs to send an email to "[email protected]"
5. Identify if there is a new unique number in column A, if so, continue steps 1-4 until all unique references are completed. If no, stop VBA
How can i get VBA to recognize the 'unique' reference number and copy over the appropriate columns, and then start with the next unique line?
I have attached the sample files and hopefully, with your assistance, I can get this automated.
Thanks!
Bookmarks