G
Guest
I have a worksheet that has column a (dates), column b (dollars collected),
and column c (method). I am trying to figure out how to right a code that
would pop-up two inputbox's, the first asking for the start date and the
second requesting the end date, then this range of dates would then tell the
code to select the entire row for any date inbetween and copy it to a new
worksheet. I can figure out the input box and the copy and paste portion but
not the middle part where the code selects everything within the date range.
Example: start is 2/1/06, end is 3/1/06. then go to the spreadsheet and even
if the first entry is dated 2/3 and last entry is 2/28 that it would grab
those and all in between and paste to worksheet2?
and column c (method). I am trying to figure out how to right a code that
would pop-up two inputbox's, the first asking for the start date and the
second requesting the end date, then this range of dates would then tell the
code to select the entire row for any date inbetween and copy it to a new
worksheet. I can figure out the input box and the copy and paste portion but
not the middle part where the code selects everything within the date range.
Example: start is 2/1/06, end is 3/1/06. then go to the spreadsheet and even
if the first entry is dated 2/3 and last entry is 2/28 that it would grab
those and all in between and paste to worksheet2?