All I did was put a bunch of dates in random columns along with some made up data, then added a UserForm with 2 textboxes and a command button and included the code in the button's click event. I then added a second workbook to paste into. The code can fail if it can't find a particular date (hence the need for error-trapping) on the currently active sheet and the first piece of code can fail if the second date chosen is 'above' (in terms of row position) the first, which is why I posted up the second piece of code, which, so far, I can't get to not work.
You keep saying it 'doesn't work', what exactly do you mean? Does the code run, but nothing gets pasted, or does it stop with an error message?