Several years ago an EE expert wrote a macro for me that synchronized dates and corresponding values in two files. The macro assigned a value of zero to correspond with any date in the "A" file that wasn't in the "B" file". I want to modify this macro so that instead of assigning a zero value, it assigns the previous value in the list.
20120905 20120905 5
20120906 20120907 4
At present the result of running the macro is this:
What I now want is this:
I've attached the current macro. Can someone tell me how to change the code to accomplish my objective. Thanks.