Macro which ranks variables along with appended data

I have an excel sheet which contains the following:

SHEET 1, contains two data sets which consist of variables along with their rank and value. Sheet 2 contains the delta change in the variables' rank and value. The macro cross references the variables in sheet one and gets the difference in the variables' rank and value. The result is then outputted into sheet 2.
The following conditions apply:
If a variable is no longer found in the current data set then its rank and value would return an empty cell or 0. If a variable had no change between yesterday's data and today then a 0 would be returned. If a variable was not recorded the previous data set but recorded on the current data set then 0 would be returned. *notice that the date is printed simply as a reference.

I appreciate your help.

Formula:

Please Login or Register  to view this content.

This should do it:

Please Login or Register  to view this content.