Excel 2003, Windows XP Pro

I have a client who has customer lists with dates and Balances Due that are
in Excel format. She would like to be able to have an input box pop up when
needed that will prompt her to enter a date range, which will then filter the
current data by that date range, showing only that - or, alternatively,
copying it to its own sheet in the file. The assumption is that the dates
will be different each time she does this. Making the vba Form to allow the
input is no problem, but I'm unsure on the code itself needed to accomplish
this.

Any help would be appreciated.
Thanks,
Eric H Krieger