Copy Multiple filtered data to same column

[flashdisk]

Hi all

I have a command button which filters data on worksheet "IdleTime" and copys the filtered data to to the worksheet "Idle Time M"
The data is filtered by Month (selected by comboBox8 value) and the Time "8:00 PM"
On "IdleTime" sheet Month is in Column 13 and time is in Column 2

This code works fine, however i need to also Filter the "IdleTime" data with the same month (comboBox8 Value) but this time with the Time criteria "1:00 PM" Edit and criteria "Sat" (Field 14) . This filtered data needs to then be copied and pasted in the next free cell in "Idle Time M" after the data i had already pasted previously

Currently having no luck trying to do this, please any help?

Current Code which works for copy n paste for filtered data with just month and time 8pm

Please Login or Register  to view this content.

Attached workbook aswell
Edit: please see attached in my second post
Command button 12 is located on phone performance summary Tab> Idle time/AQ Summary Tab> Idle Time summary Frame

[AlphaFrog]

Please Login or Register  to view this content.

[flashdisk]

Hi Thanks for replying AlphaFrog

Code looks great

Apologies as i forgot to include another field in the second criteria which is why the data needs to be filtered separately and pasted below

After it has copy n paste the filtered data for Criteria Month and Criteria 8 pm
The second filter needs to be Criteria Month (Field 13), Criteria "1:00 PM" (Field 2), and Criteria "Sat" (Field 14)
This is due to end of day values being entered at 8pm on weekdays and 1pm on a saturday
Hope this makes sense?

have attached workbook again with field 14 in IdleTime Sheet

[AlphaFrog]

Please Login or Register  to view this content.

[flashdisk]

Hi Thanks again for repying

When testing the code i get a debug error on the below line?

Please Login or Register  to view this content.

[flashdisk]

Found the cause, works great. Thank you