Trying to filter a column

Quote from DarrenSmith1981

The thing is I`ve no idea how to do coding on Power Query.

Can the operator control the filter in Power Query??

Yes, obviously you can very easily control the Filtering process in Power Query ... without knowing the M language ...

see a simple guide : https://excelunlocked.com/filter-sort-data-excel-power-query

Hope this will help

Are you the author of the Power Query ....?

If not ... why not asking the person who has done it for you ...

Have you tried my file

Since you are the author of the Power Query ... you do know how to navigate the Main Menu and how to use the Headers to filter any column for your reporting ...

Quote

Yes, I tried your file and I love the way you have set it up.

For some reason, it will not go beyond June?

If you are referring to my file then I have just filtered Jobs and July jobs without any issues.

Not really. All contact is supposed to be kept on the Forum.

1. The form is showed when the sheet is activated - your code.
2. The start date are entered using the calendar - I've tested it and it works.
3. Filtered data is copied to Current Jobs.

The only change that I need to make is to check whether the dates are in the correct order.

I've added that and changed the userform colours to match your original form

I wouldn't think so. Can you switch off Power Query temporarily?

No references need to be set. Try exporting the data and code to another workbook without the query

Attach that workbook so that I can see if there are any differences.

I don't what's causing this issue. The Userform works perfectly in the original workbook but there's an issue with the AutoFilter Range in the new one.

I've changed the code and it seems to be OK now. I have filtered April? may to the other sheet.