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
Bookmarks