How to update rows based on the comparison of 2 excel files and additional conditions?

Help Studio
, , ,
1

Hi,

I have the following files:

Invoices.xlsm

**
Snag_1b39579c
**

Terms.xlsx
image

This is what I’m trying to accomplish:

  1. If the column “A” of the file Invoices.xlsm (sheet “FormatedforUpload)” is = to 25,
  2. then compare column D with the file Terms.xlsx (sheet “Raw Data”) column “Supplier ID”
  3. 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”)

Expected Result:
image

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! :slight_smile: :pray:

2

ReportAutomation.zip (52.8 KB)

1 Like
3

It works! Thank you very much! :grinning_face_with_smiling_eyes:

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.