Welcome to Justanswer
I am Suryanto and I will assist you
Please check here
I hope that helped. Please remember to rate my service positively (3 stars or more) if this helped.
If you need further assistance, please do not rate me negatively with 1 or 2 stars. Instead, please reply to me so that I can help you further.
Looking forward to hearing from you
No, that's not the reason the code doesn't work.
I have tried the code and it worked. You just put the code in module and press f5 in the module to run it
I will check your file and write the macro for you if you still want to continue
When will you need this?
I will try to setup the file and let you know
Please download the file here
After you download the file, please rename the file extension from xls to xlsm
Please make sure you have enabled macro to run before opening the file
You can change the criteria in Sheet1 and the result will be displayed in Sheet2
If this solve your problem, please rate my answer 3 STARS or more so I can get paid for my time.If my answer did not work, please let me know
Please download the file copy2016a with sample filter in D1 and F1 and copy2016b with sample filter in I1 and J1
It depends on your data. Please check again
If I have helped you with your issue, please rate my answer 3 STARS or more so I can get paid for my timeIf my answer did not work, please let me know
Please don't forget to RATE my answer 3 STARS or more, so I can get paid for my time.
It will not cost anything additional beyond the value of your question
Sorry, I have spent a lot of time on this question for nothing. I have sent solution that worked
I can't help you again