Re: $$Excel-Macros$$ Most helpful Member - March 12- Don Guillett
On Saturday, April 14, 2012, Ayush Jain jainayus...@gmail.com wrote: Dear members, Don Guillett has been selected as 'Most Helpful Member' for the month of March'12 He has been helping forum members from long time consistently and we are proud to have him in the forum. He is business degree holder from University of Texas and retired Regional Manager for ING. Don, Many Many Thanks for your great contribution to forum. Keep Posting !! Best regards, Ayush Jain Group Manager, Microsoft MVP -- 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 -- With Regards SUNNY AGARWAL -- 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
$$Excel-Macros$$ Re: Help with Combo Box and Display
Hi, U just need to select the entire ROW OF COMPANY by pressing on C,D,E OR F ( the row in which Company is)only, and apply filter.your answer is solved.So,u will b able to filter only according to your choice. On Fri, Jul 10, 2009 at 6:13 PM, vivek agrawal vivek.agrawa...@gmail.comwrote: Hi ashish attached is the excel file. 1. select the sheet1 2. then run the macro attached. this will populate the combobox in the next sheet with unique items of Company_Name 3. Change your selection in the combo box and the table below gets filled accordingly.. if u make addition to the master table, you just need to run the macro once again and the combo box will get filled with the unique values automatically.. Hope this helps. Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 9, 2009 at 11:44 PM, Ashish Pradhan ashlyprad...@gmail.comwrote: Hi Been racking my brains for a few days but simply seem to have blanked out. I have an excel file with the following headers. Product|Version|Status|Date|Executive|Company Name|Contact| Note: All the rows under the headers can be repeated multiple times. Filter is an obvious method to get data fulfilling a criteria. But I would like to avoid use of Filter Is there any method wherein I can create a combo box on Company Name and get a list of all corresponding entries under the Company Name thus selected from the combo box. Further, is it possible to get only a unique list in the combo box but on selection, display all the rows and columns with the matching Company Name? This, is possible, would have to be done in a new sheet. Its ok with me as long as the combo box and display properties gets updated every time I update the list in the main worksheet. By the way, I am using Excel 2007. Thanks -- Ashish Of what use is freedom if it does not include the freedom to make mistakes -- Mahatma Gandhi -- With Regards SUNNY AGARWAL --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent!!!!!!!!!!
Hi, Select the entire row again( except text eg; Date is written as text this may be conflicting) go to Format--Cells--Customs select the date format you want.Its done.Even if this doesnt works than simply delete the entire date row insert a new row. On Fri, Jul 10, 2009 at 5:23 PM, sachinp1...@googlemail.com sachinp1...@googlemail.com wrote: Hi, I'm new one to this group. I'm facing problem in excel for Date Formating.When I'm selecting Entire column of Date, after selecting to Date option in Format, all dates are not coming in same format. Can anybody help me out in this ? Excel sheet is attached for your reference. Thanks in Advance, Sachin Patil -- With Regards SUNNY AGARWAL --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Urgent!!!!!!!!!!
On Sat, Jul 11, 2009 at 1:10 AM, Sunny Agarwal agarwal.su...@gmail.comwrote: Hi, Select the entire row again( except text eg; Date is written as text this may be conflicting) go to Format--Cells--Customs select the date format you want.Its done.Even if this doesnt works than simply delete the entire date row insert a new row.or else just copy all matter into new sheet paste it.Excel will auto recognize the date format On Fri, Jul 10, 2009 at 5:23 PM, sachinp1...@googlemail.com sachinp1...@googlemail.com wrote: Hi, I'm new one to this group. I'm facing problem in excel for Date Formating.When I'm selecting Entire column of Date, after selecting to Date option in Format, all dates are not coming in same format. Can anybody help me out in this ? Excel sheet is attached for your reference. Thanks in Advance, Sachin Patil -- With Regards SUNNY AGARWAL -- With Regards SUNNY AGARWAL --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---