Good Day,
My query is from a previous thread that has been resolved and many thanks to John Tropley for the solution.
My new query based on John's solution which works, SInce I have amended the spreadsheet to include more columns and adapt the code and when I run the macro from John's solution, I am getting the following error "- Run-time error '9': Subscript out of rangePlease Login or Register to view this content.
Essentially what is meant to happen is that any changes made on Sheet FARJUL the macro is meant to update sheet FARJUN
The code is as follows:
I have attached sample of filePlease Login or Register to view this content.
Thanks
Bookmarks