I have an invoice sheet in excel with a consolidated invoice sheet that has single invoices against multiple purchases made. These invoices i receive on a monthly basis. I also have daily invoices coming in.
I want to get a distinct list from the Monthly consolidated invoice sheet and loop through to check if i have it on my daily invoice sheet. If it is not i want to update inv_daily with the details of the invoice number.