Search 4 ranges and copy all matches

[SarahPintal]

Hi guys,

Ive been having a play with some otherway to replace the long Find code that ive used in the past.

My current code is about 100 lines long which is pretty inefficent.

Ive been able to use my code with some other code Im using for another tool I have, though i need to extend on the below so that it looks at not only D:D but also E:E and then D:D and E:E on another WS.

So basically the code looks at my input names, matches my input in the 4 ranges and copies each of the matches to the 'Server Results' WS.

The catch is if its found on the second worksheet then the heading of that second WS be written and any other entires found in that WS be placed below this.


possible?

Please Login or Register  to view this content.

[StephenR]

Yes, it is possible. Why not attach a sample workbook which illustrates your problem?

[SarahPintal]

It okay,

Did this

Please Login or Register  to view this content.