At work we get invoices on an excel spreadsheet. The spreadsheet contains company details, a reference number, and the amount invoiced. We then check each item on the invoice and mark on the spreadsheet whether or not the payment will be made.
I want to know if there is a way that when we get a new invoice for the month we can search the previous months invoices to check that they have not been invoiced again.
Anyone able to help with this?? Thanks in advance!
... a rather 'hard-coded' way would be to put vlookup formulas alongside each invoice entry to do a lookup of the reference to prior months. You'd have to amend each month. Are you familiar with vlookup?
To make it dynamic, I fear the only real way would be to load them into access or something like that OR you could write a macro that 'knows' what all the different months are likely to be called, opens them up and does a find in them.
This thread is now locked and can not be replied to.