Filter Data between 2 dates, copy, paste

**humboldtguy** · 03-02-2011, 04:41 AM

Hi, Thanks in advance for the help.

I use excel to do mileage reports for my job. I have a table of data, each line dated. I need code to gather all data between 2 dates selected by user form, copied, then pasted onto an existing worksheet named (Mileage Report) to cell K3 over and down

I currently achieve the needed results with a ton of formula that i believe slows down my program. I have attached a sample workbook. thanks again for the help

**royUK** · 03-02-2011, 05:22 AM

I've taken a quick look. Your entry form errors immediately, debugging shows that it's the
SLocNameCombo change event. This amendment prevents the error & avoids using VLOOKUP

Please Login or Register  to view this content.

I'll have a look at the filter part next

**royUK** · 03-02-2011, 05:25 AM

Which userform is to filter the dates?

**humboldtguy** · 03-02-2011, 10:17 PM

Originally Posted by royUK

Which userform is to filter the dates?

Hi royUK, thanks for takin a look at this. Sorry i just quickly moved those sheets over along with the forms.....anyway the viewMRForm currently has only 1 combobox to select a month, that will change to 2 comboboxes to select dates. I apologize for not changing that before posting.

So the end result i desire would have the end user(myself) selecting a date from each of 2 comboboxes, and having the mileage table filtered to show only data dated between those 2 dates. Next the remaining data is copied and pasted onto the mileage report starting at cell K3.

Thanks again for taking the time to look at this for me