Is there a way to simplify my code?

[lubbamkt]

Hi,

I have a spreadsheet which needs to perform the following actions
1.) base on two range value (in Col A and B) in Worksheet1 to search and find the same value in Worksheet2 to Worksheet5
2.) if can match the the value of WS1 in any of WS2 to WS5, then Copy particular cells from one of these WS to WS1

My problem is that in reality, I got around 5000 row data in each WS2 to WS5 and around 1000 row data in WS1. I did try the code in the attachment, but it takes 38 seconds to fill just 27 rows.

Can anyone tell me how should I simplify the code so that it can run faster.
Thanks

[mikeTRON]

Can you post the code to the forum?

[lubbamkt]

Here is the code.
I reupload the workbook to the forum with elaboration, wish making it much easier to read. Thank you again!

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[lubbamkt]

Hi protonLeah, thank you so much!

Please Login or Register  to view this content.

[lubbamkt]

Hi protonLeah,
Is it possible to use array to first save the result and paste them only once after searching?

Please Login or Register  to view this content.

[lubbamkt]

Can anyone give me a hand pls?

[protonLeah]

I'll have a look Sunday.

[lubbamkt]

Sure. Np. Thanks in advance

[protonLeah]

Please Login or Register  to view this content.

[jindon]

See if this is faster.

Please Login or Register  to view this content.