Macro to select filtered data is inconsistent..

[Dahlia]

Dear Excel Experts,

I've been trying to find solution for this for almost a week but to no avail. Just really don't understand which part I've done wrong.

My code below should do copy to filtered data and paste them below the row (skip one blank row to differ) of the original data. The original data is in csv format which located in separate workbook. It has a checking command line to ensure that the filtered data is not blank, else skip and run next sub macro. This is needed to run through thousands of original data in separate workbooks. The weird thing that happens is that some files, the macro detects blank correctly, some won't and will prompt the error and stops the macro. I tried to change between count and countA for detecting the filtered data rows but if i do that the result will also be different, as if some of it is detected as text so, it will count in CountA but some will only be counted if using Count.. I have tried different version of Excel, ranging from 2010 up to 2016 but no difference.. I have tried many different macro commands to count only visible data rows but still don't give any difference.

This has been so much pain for me as I need to get accurate data to calculate SLA performance of each staff in attending tickets. Please, please, please help me..

Please Login or Register  to view this content.

[Richard Buttrey]

Almost impossible to comment without seeing the workbook. Please upload this and the csv file on which it is dependent.
Many of us would prefer to go back to basics since often we can find more efficient ways of achieving your goal.
So in a separate note clearly explain what you start with, what you want to do and what the results should be. Be sure to manually add the results and layout you expect to see on a separate worksheet. Once we can see the goal and what you start with we'll be able to comment further.

[Dahlia]

Hello Richard Buttrey,

Firstly, I really thank you for your swift response. After your reply, I suddenly had an idea to overcome this problem. I tested it and it worked just as I really need it. What I did was create another submacro which actually puts a formula to define "YES" if meet criterias either in col D or E. Then I filter data based on "YES". After that, followed by all my other formulas. So, only when I do this that I can have an accurate number of filtered data rows that match my criterias for each file and I don't encounter error anymore..

*phew* what a relief! After almost a week of sleepless nights.... only after I posted my problem here that I finally got the correct solution!.

Thanks to you and all who may have spent sometime to read my problem and trying to create for solution.

With this, I consider this issue is closed and solved.

Thank you for your time.

[jaslake]

Hi Dahlia

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.