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
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
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:
- Need a macro to searched data in another Excel
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Gif in excel - Guide
- Tmobile data check - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
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
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 :)
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 :)
Jul 20, 2015 at 12:13 PM
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
Jul 21, 2015 at 05:11 AM
Jul 20, 2015 at 02:22 PM