Posts by DarrenSmith1981

I turned the power query off but still no joy

Sorry just can`t understand it because I am sure your coding is right.

But why should it work on your end but not mine??

Could it be something to do with References in VBA?

Still not working?

Would it be not working on my end because it`s linked to a power query?

I am not going to use this file so I need a user to filter the columns that`s why I am trying to make the VBA form work.

Roy

Sorry, any chance of a quick zoom meeting?

Just can`t make it work this end??

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

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

I am the author of the Power Query

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

For some reason, it will not go beyond June?

It filters only April to June even though I chose April to October.

The worksheet is feed by a power query don`t know if that would make any difference

I love the way you have done the code though brilliant.

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

Can the operator control the filter in Power Query??

Sorry still no luck

Sorry still the same story wonder if it`s because the spreadsheet has a power query behind it.

Could we arrange a zoom meeting?

The filter not working properly sorry because it just clears all the data on the TGS JOB RECORD sheet?

Then fills all the data back in.

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

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?

That`s what i did?

I`ve downloaded your code it now Says invalid month it msg box

In an inputbox

I think using the realistic completion date as the reference would be the right way.

It never worked right.

At the moment I have been trying to filter between April and October

Sheet 1 is TGS JOB RECORD then Destination Sheet is Current Jobs

Here is the workbook in questionJob Planner Details.xlsm