How to find , match , copy paste and insert

Closed
Report
-
 Blocked Profile -
Hello,

How to find a particular data in multiple worksheet based on the single character that we appointed , match it then copy the value of the data and paste it in a worksheet that I selected , if the row > 1 , how to copy it and insert into the worksheet selected.

1 reply


Dear Ang,

Please find the solution from the below link:

https://ccm.net/faq/4696-excel-a-macro-to-copy-paste-a-selected-range

Thanks in advance.