I am looking to search for a list of data from a given spreadsheet in a masterlist with the data scattered around and then update the cells in the masterlist with the data in the given spreadsheet. The process of doing so is as described. In the given spreadsheet, i copy the value in lets say C2 and go to the masterlist and search for the value. Once the value is found, i go back to the given spreadsheet and copy a few cells to the right of it and paste it a few cells away in the masterlist. I am able to do it for the first row and loop the macro but can't seem to change the text to search to another value. Really appreciate if somebody could help take a look at my code to see where it can be improved on.

Please Login or Register  to view this content.
Thanks in advance!