Need a macro to searched data in another Excel

Closed
Report
-
Posts
14
Registration date
Thursday July 16, 2015
Status
Member
Last seen
August 14, 2015
-
Hello,
I have a requirement , where in in one excel sheet i have data with 5 columns (A, B , C , D , E)
now i want to search the excel on data with column A , where in i want to pass 20 strings at a time to search ,
if the record is found , then copy the entire row in another sheet and if the record is not found then copy that string in another sheet.

Any help will be appreciated a lot


1 reply

Posts
14
Registration date
Thursday July 16, 2015
Status
Member
Last seen
August 14, 2015
1
hey nishi i prepared a workbook.hope that will work for you
im new here.i dont know how to upload that file here.text me your email address or method to upload a file here whatever is convenient for u.if u find workbook helpful dont forget to thnx :)
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi M.Hanzla,

Workbooks are uploaded by going to a free file sharing site like www.speedyshare.com or ge.tt among others. Then post back the download link.

Do keep in mind that these uploaded files are only accessible for a limited time, so it is a better option to post your code directly. Alter the way your code looks by selecting your code and using the <> button above the message body (next to the B, I and S buttons) and choosing the programming language you used.

See you around,
Trowa
Posts
14
Registration date
Thursday July 16, 2015
Status
Member
Last seen
August 14, 2015
1 >
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021

Thank You trowaD :)
Hi hanzala , thanks for the workbook , it will be great if you can upload the file on the link provided by trowa