Re: $$Excel-Macros$$ need VBA Code plz help
Have you tried using datafilterautofilter 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
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/ 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
Re: $$Excel-Macros$$ need VBA Code plz help
HI Hamed, Attachment is missing... On Sun, Mar 11, 2012 at 12:43 PM, Gulam Hameed gulamham...@gmail.comwrote: 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/*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.