What you want can be done but why not just goto the db sheet and filter??? Don Guillett SalesAid Software dguille...@gmail.com
From: SAJID MEMON Sent: Tuesday, December 20, 2011 10:15 AM To: Sundarvelan Natarajan Subject: $$Excel-Macros$$ Searching Query Dear Expert I want to make some search from database sheet. if i want to type in sheet1 e3 cell what ever data that should show below example wise just type my name "sajid" that will show below. I want when i type any PAN catagory or VAT No catagory then it shows maching rows all data. please co-operate me in vba coding (FILE ATTACHED) Regards Sajid Memon -- FORUM RULES (934+ 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 (934+ 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