Need a macro to searched data in another Excel

Closed
Nishi - Jul 19, 2015 at 04:29 AM
M.Hanzla Posts 14 Registration date Thursday July 16, 2015 Status Member Last seen August 14, 2015 - Jul 21, 2015 at 05:11 AM
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

M.Hanzla Posts 14 Registration date Thursday July 16, 2015 Status Member Last seen August 14, 2015 1
Jul 20, 2015 at 08:51 AM
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 :)
0
TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022 541
Jul 20, 2015 at 12:13 PM
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
0
M.Hanzla Posts 14 Registration date Thursday July 16, 2015 Status Member Last seen August 14, 2015 1 > TrowaD Posts 2913 Registration date Sunday September 12, 2010 Status Moderator Last seen November 21, 2022
Jul 21, 2015 at 05:11 AM
Thank You trowaD :)
0
Hi hanzala , thanks for the workbook , it will be great if you can upload the file on the link provided by trowa
0