Hi,
The code I posted was sample code and you would need to change the referencing in it to accomplish what you need.
You go the error since the Find command was not able to locate a match in Sheet 2 and Row 2 for the value in Sheet 1 and cell A1.
The code below is a bit more "stable" as it hase some logical error handling in it. If it finds no matching value in row 2 based on the value in A1, it does nothing instead of debugging. Also, I don't know what value you will be picking up in the YearEndFigures, so I made the variable variant, to store anything...
Try it out now and make reference adjustments as needed...
Bookmarks