See the attached file.. Result on Sheet 2
Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of prabhat.shrivasta...@gmail.com Sent: 29 April 2012 22:10 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Find the cell value from other sheet Dear Frnds, I've a data sheet(reports) containing some data text in several row of entire sheet & have another sheet(user ids) in column A containing few words these words may be or may not be the part of other sheet(report) text in cell of column A, now i wanna know if the sheet(user ids) text mentioned in column A are available in entire sheet(reports) or not, if yes than column B contain the result as "Found". Regards, Prabhat Shrivastava -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
