Matching up output

Help
1

Hello i have a process that runs and matches up between two sets of data (Invoice data.xlsx and UK Updated 3.xlsx. Currently it is only outputting the matches from the second (UK Updated 3) to a separate excel document. Instead i want to match it up to the original data in the Invoice data.xlsx. So that if there is no match it writes a blank line.

FAME Match.xlsx (7.6 KB)
Invoice Data.xlsx (994.2 KB)
UK Updated 3.xlsx (14.8 KB)
Update_Invoice_Data.xaml (26.0 KB)

2

Solved. I’ve modified so if the count = 0 it adds a blank row.

3

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