I want a macro that will compare two different sheets. In both sheets column B will contain dates. I want the macro to look at sheet1 at the last row of data in column B and add 1 day. I then want it to go to sheet2 and look for this date and when it finds it copy all the data from then downwards to sheet1 at the very bottom.