I am trying to write value in column A based if there is a value in column B.
the document will be received in the following format.
column A2 has the vendor number and column B has the invoices from cell B2:dynamic number of cells "each document will have different number of invoices"
the following example is not working and not sure why it is not able to write the value.
StatementReview_PRD_VenNum - Copy.zip (8.1 KB)