Need a macro to searched data in another Excel

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


Related:

1 response

M.Hanzla Posts 14 Registration date Thursday 16 July 2015 Status Member Last seen 14 August 2015 1
20 Jul 2015 à 08:51
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 :)
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
20 Jul 2015 à 12:13
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
M.Hanzla Posts 14 Registration date Thursday 16 July 2015 Status Member Last seen 14 August 2015 1 > TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022
21 Jul 2015 à 05:11
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