I have the following files:
This is what I’m trying to accomplish:
- If the column “A” of the file Invoices.xlsm (sheet “FormatedforUpload)” is = to 25,
- then compare column D with the file Terms.xlsx (sheet “Raw Data”) column “Supplier ID”
- If both columns match, then copy the data that is between () of column “Payment Term” to column F into the file Invoices.xlsm (sheet “FormatedforUpload”)
How can I do that?
This is what I have so far…
ReportAutomation.zip (83.1 KB)
Any help you can give would be greatly appreciated!