Copy Entire Row Data if Multiple Filtering Condition was met.

[Malou]

Hi Everyone,

Need help on how to filter my data using values in 2 columns. I have below the code created for me and this filters only one column and if the values are true, it will copy the entire row to master file. The filter that i need to add involves Time (AM/PM). Let's us say, in the morning, if I run the macro to copy.. it will copy only the data where the time is AM and then, in the afternoon, the data with PM time should be ADDED to the AM data.

Please Login or Register  to view this content.

thanks in advance for helping.

[JBeaucaire]

As per forum rules, please edit post above and add proper code tags around your code, do it quickly before your post is infracted by a moderator. Thanks.



Also, update your sample workbook to demonstrate the new values you want evaluated.

[Malou]

hi Jerry..

thanks for reminding.

[JBeaucaire]

Maybe....

Please Login or Register  to view this content.

[Malou]

hi Jerry,

I have another favor, what if the time range for AM is 8:45am to 1:00 PM, then for PM is 2:00pm - 6:00pm?

[JBeaucaire]

I'd say it's time for you to figure out what this macro is doing, and edit it accordingly.

The macro is inserting a REGULAR WORKSHEET FORMULA into column Z, then filtering on the TRUE/FALSE results.

The formula being inserted into Z6:Z???? is:

=AND($D6<>"", ISNUMBER(MATCH($D6, $U$6:$U$13, 0)), MOD($I6, 1) < 0.5)

So for you to continue tweaking this macro, you just to tweak this first formula. Once you get the formula working the way you want, then record yourself entering that formula into Z6. Turn off the recorder, and now you have a VBA version of that same formula:

.....FormulaR1C1 = "=AND(RC4<>"""", ISNUMBER(MATCH(RC4, R6C21:R13C21, 0)), MOD(RC9,1)<0.5)"

OK?

So, 0.5 is "12noon" in Excel decimal values. You can enter whatever time you want into any cell anywhere, then change the formatting of that cell to General and you'll be able to see the decimal value for that time. For instance, 8:45 AM in a cell, GENERAL = 0.364583333.

Just add more parts to the AND() formula above. To get a time between two other times you would need to add two more parts to the formula:

MOD(RC9, 1) >= timevalue
MOD(RC9, 1) < timevalue

[Malou]

hi Jerry,

Thank you very much for helping. It works exactly what I wanted.

As i have mentioned from my other post, I'm a newbie and have a little understanding in codes...I really appreciate your help and patience in explaining it.

Cheers!