Hi folks,
I am trying to create a spreadsheet that will help identify duplicate invoice payments made to our ERP system on a daily basis. I would like one tab to have all the data loaded from the current fiscal year, and then a daily import of the previous days invoice payments. I would then like to match the previous days payments up with anything that's already loaded with the same vendor, invoice number and amount. Is there a way that after the daily import and you review to see if there are duplicates or not, the data would then automatically go to the tab with the master data so everyday you start with a "fresh" page?
I am trying to create a spreadsheet that will help identify duplicate invoice payments made to our ERP system on a daily basis. I would like one tab to have all the data loaded from the current fiscal year, and then a daily import of the previous days invoice payments. I would then like to match the previous days payments up with anything that's already loaded with the same vendor, invoice number and amount. Is there a way that after the daily import and you review to see if there are duplicates or not, the data would then automatically go to the tab with the master data so everyday you start with a "fresh" page?
