Copying filtered data from 1 sheet to another

Hello UltimateNeo,

A quick glance shows me a couple of issues with the posted code.

The first one that may explain some of the behaviour is the paste command. Finding the last used row works well but only the first time in a loop, it seems the values only get actually recalculated after a save function at a minimum so the Range B1000 etc will always return the same value of 14 and add the offset to paste into row 15.

The second issue I see is that the copy commands seem to be copying the cells in the Sheet2 tab and not the Data tab you think they are. haven't worked that one out yet as I am not a big "Range" and "With" person, generally taking the long way out

I did have to slightly restructure your If Else If commands so they made more sense to me.

I note that you have no code currently to deal with the input fields from Sheet2 being all blank (and having the blue background on all cells with no indication of input cells is a bit confusing initially) - obviously I hit that error condition straight up )

version with some changes attached

just some rapid thoughts

Hello again,

I have had a few more goes and managed, by only considering "JobNo", to get it "sort of" working.

I take no real pride in the sloppy code except that it appears to work, my only defence

There is still a fair bit of work needed to work out the code for other search options AND to consider what is the desired outcome if multiple search terms are entered.

Hope this gives you some direction, am Ok to continue if you need more assistance but in the meantime OTY

You are welcome,

It did occur to me that an alternative solution might be to filter the Data sheet and then work with the visible rows after the filter (s) have been applied.

If you are indeed only going to process one of the inputs then apart from handling the "none at all" you would need to ensure the expectations of the "correct result" are clear if an operator entered multiple search inputs.

Users will always do what you least expect them to do, despite any instructions to the contrary

Thanks for the rep, appreciated