Have you tried using data>filter>autofilter>> Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com
From: Gulam Hameed Sent: Sunday, March 11, 2012 1:13 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ need VBA Code plz help Dear Noorain & experts I want make invoice in easy & shortcut method like eg: order number 8241 2012, it has 12 items codes, Description, Price Qty & Total Amount, I need some kind of VBA code which give all order details once select order No in cell (G5) all the data pertaining with that particular order number it has to appear in (A18:G38) automatically, if I use function vlookup it displays only one row with details, in this case I want total rows with order details. That was a example sheet, I have huge data to do this its take much time to process, I need your help in order to save time. Thanks in Advance Gulam Hameed From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Friday, March 09, 2012 5:25 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ ORDERS SHEET 2012.xlsm Dear Hameed, Please explain more what is your adject requirment........... -- Thanks & regards, Noorain Ansari http://noorainansari.com/ http://excelmacroworld.blogspot.com/ On Thu, Mar 8, 2012 at 3:35 PM, Gulam Hameed <gulamham...@gmail.com> wrote: Dear All Experts…..!! WISH U ALL EXPERTS HAPPY HOLI……!!! Can some help me out please find attach example sheet Thanks & Best Regards Gulam Hameed -- 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 -- 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
