I have a code running on my accounting spreadsheet that is supposed to move an invoice from one worksheet to another when its status is changed from a dropdown. for example - Invoices come in and are input onto this spreadsheet and once paid, i want them to move accross to a worksheet called 'Approved' and then if disputed move to a different worksheet.
The code i have in place is as follows.
Everytime i try and change the status of an invoice, i get a runtime error 424. However it does still run the macro ie the invoice moves accross anyway!
Please Login or Register to view this content.
Any help/advice would be appreciated.