Trying to filter a column

    In the Message Box which accepts your months as names ... ;)


    you should type in April for the start month and October for the end month ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Sorry ... but just re-tested the macro, at my end, and it is working fine ...


    May be you have performed many tests with many files ...


    Just close down Excel to clear your computer's memory ... and test again your test file ...:)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Another point regarding your macro ...


    In my message #15 ... have asked you the following


    " There is a rule you are imposing yourself ... which is not to be able to input the Month shown in the first six rows ..."


    Are you aware of this feature ? And is it a valid requirement ?


    You have not answered this question ....

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    If I may ask ... are you the author of these different macros ... ???


    Why is there a rule to prevent the User from picking the Months he wants ... ???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Another point regarding your macro ...


    In my message #15 ... have asked you the following


    " There is a rule you are imposing yourself ... which is not to be able to input the Month shown in the first six rows ..."

    Are you aware of this feature ? And is it a valid requirement ?


    You have not answered this question ....


    How is this rule imposing on me?

    I`ve saved your one it does filter I think but does not fill detail to the destination sheet?

    Quote

    I`ve saved your one it does filter I think but does not fill detail to the destination sheet....


    Are you saying the macro is ... now filtering correctly ... BUT not copying the results, as it should, to the Destination sheet ... ???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    1. Do you get the final message Box which says : Data transferred!


    2. Do you see only your filtered records in a sheet named Current Jobs ...???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    1. Do you get the final message Box which says : Data transferred! Yes I do


    2. Do you see only your filtered records in a sheet named Current Jobs ...??? There is no data on the Current Jobs sheet except for the headers. Should see only filtered data.


    3. Are you saying the macro is ... now filtering correctly ... BUT not copying the results, as it should, to the Destination sheet ... ??? Yes

    Is the Power Query connection used to populate your sheet TGS JOB RECORD ...???


    Is your Power Query using a specific Date format ...???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Did you see my message # 34 ...

    Quote

    Is the Power Query connection used to populate your sheet TGS JOB RECORD ...???


    Is your Power Query using a specific Date format ...???

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Sorry for my stupid remark ...


    But since you are using Power Query to generate the whole of your Database of Job Records ....


    Why don't you also use Power Query M language to perform the Filtering you need ... ???


    In addition, the reporting will be fully automatic ... without the need of any macro ...:):):)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    Your code is way too complicated.


    Using InputBoxes to return a month gives a String, this need s converting to a numeric value.


    I've edited your userform to use calendar to select the dates from.


    This works very quickly and uses 28 lines of code for the filter.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login