Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other
Hi Noorain On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Cab, Question -1, you can use attached Add in to Compare two worksheets.. Question -2, You can group both sheets to same entry on same time. Press ctrl+shift+Pg down.. Thanks for your reply and attachment. However the attachment opens Excel but will not show the workbook. If you could check and resend for me that would be great. Thanks and regars Charlie Harris On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose swch...@gmail.com wrote: Hi OOPS This time attached. Thanks Charlie On Tue, Aug 30, 2011 at 9:32 AM, Cab Boose swch...@gmail.com wrote: Hi and oops. Attached now. On Mon, Aug 29, 2011 at 7:50 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Attachment Missing. On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose swch...@gmail.com wrote: Hi I have in attached workbook: Has two worksheets- 'ByGroups' and 'ByAssly The two sheets should be the same, however they are in different order. First Question: Which is the best way to find the differences between the two sheets as at the moment so that corrections can be made. Have searched google etc Looks like I need a match/vlookup ?? or probably vba would be better ? Would like to see a separate sheet with the differences. Second Question: Once the sheets are sorted, I want to be able to have entries made onto the part # in each sheet at the same time. eg if I have part # 27184 I want to enter 'InStock' number entered on both sheets against that number. I think a user form could be used, but I do not know how to get both sheets entered at the same time. The user form would show the 5 column heading (on the RHS) Your comments and guidance would be appreciated. Thankyou Charlie Harris -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5.
Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other
Dear Cab, Actually it is Add-In file when you click on this, it will be Show in Add-in Menu bar when you need it can be use.. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Tue, Aug 30, 2011 at 12:10 PM, Cab Boose swch...@gmail.coim wrote: Hi Noorain On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Question -1, you can use attached Add in to Compare two worksheets.. Question -2, You can group both sheets to same entry on same time. Press ctrl+shift+Pg down.. Thanks for your reply and attachment. However the attachment opens Excel but will not show the workbook. If you could check and resend for me that would be great. Thanks and regars Charlie Harris On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose swch...@gmail.com wrote: Hi OOPS This time attached. Thanks Charlie On Tue, Aug 30, 2011 at 9:32 AM, Cab Boose swch...@gmail.com wrote: Hi and oops. Attached now. On Mon, Aug 29, 2011 at 7:50 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Attachment Missing. On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose swch...@gmail.comwrote: Hi I have in attached workbook: Has two worksheets- 'ByGroups' and 'ByAssly The two sheets should be the same, however they are in different order. First Question: Which is the best way to find the differences between the two sheets as at the moment so that corrections can be made. Have searched google etc Looks like I need a match/vlookup ?? or probably vba would be better ? Would like to see a separate sheet with the differences. Second Question: Once the sheets are sorted, I want to be able to have entries made onto the part # in each sheet at the same time. eg if I have part # 27184 I want to enter 'InStock' number entered on both sheets against that number. I think a user form could be used, but I do not know how to get both sheets entered at the same time. The user form would show the 5 column heading (on the RHS) Your comments and guidance would be appreciated. Thankyou Charlie Harris -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel --
Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other
Hi Noorain Thanks for that. It does not show in the add-in at the moment. Have opened Excel and then opened the file you sent. Is there a process that I should foolw ? Thankyou Charlie On Tue, Aug 30, 2011 at 7:43 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Cab, Actually it is Add-In file when you click on this, it will be Show in Add-in Menu bar when you need it can be use.. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Tue, Aug 30, 2011 at 12:10 PM, Cab Boose swch...@gmail.coim wrote: Hi Noorain On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Question -1, you can use attached Add in to Compare two worksheets.. Question -2, You can group both sheets to same entry on same time. Press ctrl+shift+Pg down.. Thanks for your reply and attachment. However the attachment opens Excel but will not show the workbook. If you could check and resend for me that would be great. Thanks and regars Charlie Harris On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose swch...@gmail.com wrote: Hi OOPS This time attached. Thanks Charlie On Tue, Aug 30, 2011 at 9:32 AM, Cab Boose swch...@gmail.com wrote: Hi and oops. Attached now. On Mon, Aug 29, 2011 at 7:50 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Attachment Missing. On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose swch...@gmail.comwrote: Hi I have in attached workbook: Has two worksheets- 'ByGroups' and 'ByAssly The two sheets should be the same, however they are in different order. First Question: Which is the best way to find the differences between the two sheets as at the moment so that corrections can be made. Have searched google etc Looks like I need a match/vlookup ?? or probably vba would be better ? Would like to see a separate sheet with the differences. Second Question: Once the sheets are sorted, I want to be able to have entries made onto the part # in each sheet at the same time. eg if I have part # 27184 I want to enter 'InStock' number entered on both sheets against that number. I think a user form could be used, but I do not know how to get both sheets entered at the same time. The user form would show the 5 column heading (on the RHS) Your comments and guidance would be appreciated. Thankyou Charlie Harris -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and
Re: $$Excel-Macros$$ Stock Sheets x 2 to equal each other
Dear Cab, Process to add Add-Ins in Excel Ribbon Excel Option-Add-Ins-Manage-Excel Add-Ins-Go-Ok You can see below link.. http://www.lytebyte.com/2009/01/08/how-to-add-and-remove-excel-add-in-or-plugins/ -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Tue, Aug 30, 2011 at 1:23 PM, Cab Boose swch...@gmail.com wrote: Hi Noorain Thanks for that. It does not show in the add-in at the moment. Have opened Excel and then opened the file you sent. Is there a process that I should foolw ? Thankyou Charlie On Tue, Aug 30, 2011 at 7:43 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Actually it is Add-In file when you click on this, it will be Show in Add-in Menu bar when you need it can be use.. -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Tue, Aug 30, 2011 at 12:10 PM, Cab Boose swch...@gmail.coim wrote: Hi Noorain On Tue, Aug 30, 2011 at 2:32 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Question -1, you can use attached Add in to Compare two worksheets.. Question -2, You can group both sheets to same entry on same time. Press ctrl+shift+Pg down.. Thanks for your reply and attachment. However the attachment opens Excel but will not show the workbook. If you could check and resend for me that would be great. Thanks and regars Charlie Harris On Tue, Aug 30, 2011 at 3:04 AM, Cab Boose swch...@gmail.com wrote: Hi OOPS This time attached. Thanks Charlie On Tue, Aug 30, 2011 at 9:32 AM, Cab Boose swch...@gmail.comwrote: Hi and oops. Attached now. On Mon, Aug 29, 2011 at 7:50 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Cab, Attachment Missing. On Mon, Aug 29, 2011 at 1:17 PM, Cab Boose swch...@gmail.comwrote: Hi I have in attached workbook: Has two worksheets- 'ByGroups' and 'ByAssly The two sheets should be the same, however they are in different order. First Question: Which is the best way to find the differences between the two sheets as at the moment so that corrections can be made. Have searched google etc Looks like I need a match/vlookup ?? or probably vba would be better ? Would like to see a separate sheet with the differences. Second Question: Once the sheets are sorted, I want to be able to have entries made onto the part # in each sheet at the same time. eg if I have part # 27184 I want to enter 'InStock' number entered on both sheets against that number. I think a user form could be used, but I do not know how to get both sheets entered at the same time. The user form would show the 5 column heading (on the RHS) Your comments and guidance would be appreciated. Thankyou Charlie Harris -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ --
RE: $$Excel-Macros$$ Sumproduct using VBA
Hello, Use : a = SUMPRODUCT(--( rng1 = BEL ),--( rng2 = AAO ),--( rng4 )) HTH Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Chandra Shekar Envoyé : lundi 29 août 2011 16:37 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Sumproduct using VBA Hello, Could you please let me know whats the error in using sumproduct function in below code. I am getting error number 2015 Is there any other way to use sumproduct function using vba with multiple condtions. Thanks in advance. Sub ABNAMROAdd() Dim compnm As String lastcl = ThisWorkbook.Worksheets(ABN AMRO).Cells(4, Columns.Count).End(xlToLeft).Column 'WeekNum = Weeknumber(Date) 'WeekNum = CurWk x = ThisWorkbook.Name y = ThisWorkbook.Worksheets(12).Name Z = '[ x ] y '! lastrow = ThisWorkbook.Worksheets(AR).Cells(Rows.Count, 1).End(xlUp).Row rng1 = Z A2:A lastrow rng2 = Z C2:C lastrow rng3 = Z D2:D lastrow rng4 = Z E2:E lastrow rng5 = Z H2:H lastrow a = SUMPRODUCT(--( rng1 = BEL ),--( rng2 = AAO ),--( rng4 )) cnt = Application.Evaluate(a) End Sub -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com To post to this group, send email to mailto:excel-macros@googlegroups.com excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Fwd:Job
- Original message From:Teamware Solutions (quantum leap consulting) sw...@twsol.com Date: 30 Aug 11 12:43:07 Subject: Urgent Requirment for MS SQL server 2005/2008Developers for TCS, Kochi To: venkatesa...@in.com The sender of this email is registered with Naukri.com as Teamware Solutions (quantum leap consulting) Experience required for the Job: 4 - 8 yearsJob Location: Ernakulam / Kochi / Cochin Dear Candidate,Warm Greetings!! We are Teamware Solutions, a professional IT services company head quartered in Bangalore. Teamware is a division of Quantum Leap Consulting Pvt. Ltd. and we specialize in contract staffing, placements and executive search. Our clientele include some of the best names in the IT industry worldwide like HP, Accenture, Deloitte, Cap Gemini, EDS, TCS, ATOS, to name a few. Our offices in Bangalore, Chennai and Mumbai look after our client's domestic requirements and our Singapore outfit, Teamware Solutions Pte Ltd. takes care of requirements in the Asia-pacific region. The choice of clients and our presence in national and international market can assure you of our commitment in providing you the best of opportunities and ending your search for a dream job. Mandatory Skill: MS SQL server 2005/2008 Exp Level: 4 Yrs Location: Kochi Client : TCS Note: Candidates who can join within short notice period (10-14 days) from the date of selection need to apply for this position. Also mention the details given below. Willingness to work on the direct payrolls of Teamware Solutions- Yes/No Total Experience: Relevant Experience: Current CTC: Expected CTC: NTC: Official Mail: Date of Birth- Educational Details-(Mention if regular or Correspondence): Current Company: Current Location: Preferred Location: If this mail is irrelevant to you kindly oblige and Ignore this Mail Thanking You Wishing you a nice day ahead !!! Warm Regards, Thanks regards Swati Teamware Solution 201-203, First Floor , Oxford Chambers, Rustambagh Road Off: Airport Road, Bangalore-560017 email-sw...@twsol.com office-08040818510 website:www.teamwaresolutions.netIs this job relevant to you? Yes No Your feedback would help us in sending you the most relevant job opportunities Disclaimer: The sender of this email is registered with naukri.com as Teamware Solutions (quantum leap consulting) (ad...@twsol.com, 305, 2nd Floor, Oxford House Rustum Baugh, OFF OLD AIRPORT ROAD BANGALORE, BANGALORE, Karnataka - 560017) using Naukri.com services. The responsibility of checking the authenticity of offers/correspondence lies with you. If you consider the content of this email inappropriate or spam, you may:Report abuse by forwarding this email to: compliance@naukri.comYou can also Block this Company from searching your resume in the database. Advisory: Please do not pay any money to anyone who promises to find you a job. This could be in the form of a registration fee, or document processing fee or visa charges or any other pretext. The money could be asked for upfront or it could be asked after trust has been built after some correspondence has been exchanged. Also please note that in case you get a job offer or a letter of intent without having been through an interview process it is probably a scam and you should contact compliance@naukri.comfor advise. To be on the top of Employer's Resume Search Update Your Resume Now Your Resume has only 30 seconds to impress a Recruiter. Get your resume written by Experts. Call 1800-102-5557 now! (Toll-Free) -- *Best Regards,* *Venkat * *Chennai* * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Fwd: Opening for SQl Developer in Chennai with Ramco Systems
- Original message From:Magna Infotech Pvt Ltd car...@magna.in Date: 30 Aug 11 12:28:42 Subject: Opening for SQl Developer in Chennai with Ramco Systems To: The sender of this email is registered with Naukri.com as Magna Infotech Pvt Ltd Experience required for the Job: 3 - 7 yearsAnnual Salary of the Job: 0.0 - 0.0 LacsJob Location: Chennai Dear Candidate,Hi, This is Arati from Magna InfoTech Pvt. Ltd, Hyderabad. Let me take this opportunity to introduce Magna InfoTech Pvt. Ltd. We are one of the most dynamic and fast growing IT Staffing in India. An ISO 2008 Certified Company Spread across 7 Different locations. Currently we have an exciting opening with us at our client place Ramco Systems Chennai Job Details Skills SQL Development exp Exp :3-7 yrs Location: Chennai if interested please reply back with your updated resume and following details: Current Company: Total Exp: Relevant Exp: Current CTC: Expected CTC: Notice Period: (less notice period will be prefferd) (Please refer any of your friends who are interested and desperately looking out for change) Thanks Warm Regards, Arati C|IT Resource| Desk- 040 39179092, Email ID: car...@magna.in www.magna.in| Magna InfotechIs this job relevant to you? Yes No Your feedback would help us in sending you the most relevant job opportunities Disclaimer: The sender of this email is registered with naukri.com as Magna Infotech Pvt Ltd (psa...@magna.in, 6-2-47, 2nd Foor, Yeturi Towers Advocate Colony,, A.C.Gaurds Hyderabad - 54, HYDERABAD, Andhra Pradesh - 54) using Naukri.com services. The responsibility of checking the authenticity of offers/correspondence lies with you. If you consider the content of this email inappropriate or spam, you may:Report abuse by forwarding this email to: compliance@naukri.comYou can also Block this Company from searching your resume in the database. Advisory: Please do not pay any money to anyone who promises to find you a job. This could be in the form of a registration fee, or document processing fee or visa charges or any other pretext. The money could be asked for upfront or it could be asked after trust has been built after some correspondence has been exchanged. Also please note that in case you get a job offer or a letter of intent without having been through an interview process it is probably a scam and you should contact compliance@naukri.comfor advise. To be on the top of Employer's Resume Search Update Your Resume Now Your Resume has only 30 seconds to impress a Recruiter. Get your resume written by Experts. Call 1800-102-5557 now! (Toll-Free) *Best Regards,* *Venkat * *Chennai* * * -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ xls to Pdf in VBA error
Dear Sajid, Please change blue color path as per your system.. This code is working fine in my systems.. *Once again.try..* ** *Private Sub CommandButton1_Click() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1)* *ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False End Sub * On Tue, Aug 30, 2011 at 2:06 PM, SAJID MEMON sajidwi...@hotmail.com wrote: Dear sir, I have copy below code and paste in excel 2003 but it shows some error and its not working in my all three systems. I have attached that image in my attachment. Please co-operate me for accomplish my project. awaiting your reply sajid memon -- Date: Mon, 29 Aug 2011 20:01:33 +0530 Subject: Re: $$Excel-Macros$$ xls to Pdf in VBA From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear KBJ, W/S... That converter is working fine on my system.. press alt+F11 and Paste it code in Module and Press F5. I hope it will work fine.. Sub exltopdf_converter() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1) ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False end Sub On Mon, Aug 29, 2011 at 3:35 PM, Advocate kbj msma@gmail.com wrote: dear Noorain Ansari (Assalamulaikum) as per your tryit.xls its not working. plz give me detail. with advance Happy Eid Mubarak to all. sajid memon On Sat, Aug 27, 2011 at 10:14 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sajid, As per your requirement Please try blow VBA code to Convert Excel file in PDF. Change path as per ur conviniece.. See attached sheet *Private Sub CommandButton1_Click() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1)* *ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False End Sub * Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Sat, Aug 27, 2011 at 4:28 PM, SAJID MEMON sajidwi...@hotmail.comwrote: Dear Experts, I want an active sheet with command button (EXCEL 2003) convert into pdf file. when i click on command button it convert and should be open in pdf format. Is it possible in excel 2003 version, if Yes then please give me VBA code for my query *i don't want to use any other converter software or online website.* ** awaiting your positive responce sajid memon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ xls to Pdf in VBA error
Hi Noorian, How it will automatically save PDF Format in 2003 Version...is it available.. -- *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 2:16 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sajid, Please change blue color path as per your system.. This code is working fine in my systems.. *Once again.try..* ** *Private Sub CommandButton1_Click() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1)* *ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False End Sub * On Tue, Aug 30, 2011 at 2:06 PM, SAJID MEMON sajidwi...@hotmail.comwrote: Dear sir, I have copy below code and paste in excel 2003 but it shows some error and its not working in my all three systems. I have attached that image in my attachment. Please co-operate me for accomplish my project. awaiting your reply sajid memon -- Date: Mon, 29 Aug 2011 20:01:33 +0530 Subject: Re: $$Excel-Macros$$ xls to Pdf in VBA From: noorain.ans...@gmail.com To: excel-macros@googlegroups.com Dear KBJ, W/S... That converter is working fine on my system.. press alt+F11 and Paste it code in Module and Press F5. I hope it will work fine.. Sub exltopdf_converter() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1) ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False end Sub On Mon, Aug 29, 2011 at 3:35 PM, Advocate kbj msma@gmail.com wrote: dear Noorain Ansari (Assalamulaikum) as per your tryit.xls its not working. plz give me detail. with advance Happy Eid Mubarak to all. sajid memon On Sat, Aug 27, 2011 at 10:14 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sajid, As per your requirement Please try blow VBA code to Convert Excel file in PDF. Change path as per ur conviniece.. See attached sheet *Private Sub CommandButton1_Click() Dim wrknm As String wrknm = ActiveWorkbook.Name wrknm = Left(wrknm, InStr(1, wrknm, .) - 1)* *ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _ C:\Documents and Settings\Administrator\Desktop\ wrknm .pdf, Quality:=xlQualityStandard, _ IncludeDocProperties:=False, IgnorePrintAreas:=False, OpenAfterPublish:= _ False End Sub * Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Sat, Aug 27, 2011 at 4:28 PM, SAJID MEMON sajidwi...@hotmail.comwrote: Dear Experts, I want an active sheet with command button (EXCEL 2003) convert into pdf file. when i click on command button it convert and should be open in pdf format. Is it possible in excel 2003 version, if Yes then please give me VBA code for my query *i don't want to use any other converter software or online website.* ** awaiting your positive responce sajid memon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at
$$Excel-Macros$$ Re: Need macro to split the files
Why don't you use a pivot table with the table option to split your document by Division and Regional lead ? On 30 août, 06:52, anu gomathi anugomathi.d...@gmail.com wrote: Hi Experts, I am very new to this forum. Attached the details report the out put file. I need a macro to split the workbook as per the below condition: The detail report file should be splitted based on the divisional lead regional lead. Condition 1: while splitting the file summary should be there in the summary sheet. Better the formula would be useful instead of values. Condition2 : The Qtr code Q1 Fy12 details should come in the summary sheet rest all the qtr's should be in details sheet. Please help me in this. Thanks in advance. Regards Anu Detail report.xls 1506KAfficherTélécharger Andy Huntrods-SI Report-010811.xls 104KAfficherTélécharger -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Excel and Sending Digital Data (DDE ?)
On Aug 30, 4:55 am, Cab Boose swch...@gmail.com wrote: Hi once again This is totally new subject. I have model railroads. I would like to control from Excel. (there are some other software available but I would like to use Excel) I want to send from Excel to a bus wire digital information showing the loco number and direction of travel (fwd/rev) etc. Just for basics etc Send a message by USB to say: Controller1 Engine 5 Fwd Direction 1/2 speed In practice there would be several sets of data for different locos. There is a digital receiver in loco. (I have drawings of waveforms that it is sent over etc) I know there are lots of things to consider, but at this point I would like to know if anyone has done something similiar. Is DDE the one to us (old apparantly) or something different. I will make up a spreadsheet to show selection of loco etc It may end up being too complex for me, but I would like to give it a try and get a ssample working turning on an LED etc Thanks Charlie Harris (into model trains) This is beyond me, but the following might be a good starting point: http://msdn.microsoft.com/en-us/windows/hardware/gg487341 You will need to declare the relevant API functions in VBA before you can use them. See the following for more info: http://msdn.microsoft.com/en-us/library/bb687915.aspx This is a complex project, but should be possible in theory. Regards Steve PS I am also a model railway enthusiast, so I'd be interested in how you get on. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Named Range to Dynamic with VBA
Hi, Be cautious with this macro and keep a copy of your workbook. Look at the attached workbook in which there is an example of error. Sub test() Dim N As Name, Var As String, Tabl As Variant For Each N In ActiveWorkbook.Names If LCase(Left(N.RefersTo, 7)) =offset Then Tabl = Split(Right(N.RefersTo, Len(N.RefersTo) - 1), :) Var = Range(Tabl(0)).Resize(, 1).EntireColumn.Address N.RefersTo = =OFFSET( Tabl(0) ,,,COUNTA( Var )) End If Next N End Sub Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Cab Boose Envoyé : lundi 29 août 2011 23:39 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Named Range to Dynamic with VBA Hi I would like to select an already named range and using a command button convert it to dynamic named range by columns and rows. Is this possible ? It would be a lot quicker than doing it manually each time. I failed to make a lot dynamic when I set them up. Appreciate your help, I am aged !! (67) and do part time work just a few hours a week for a small business. Love Excel. Thanks and regards Charlie Harris -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Error.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Need macro to split the files
Hi, Can u pls explain me the steps. Any way i need the summary in the detail sheet. Regards Anu On Tue, Aug 30, 2011 at 2:52 PM, Frederic LE GUEN - MVP Excel fleg...@gmail.com wrote: Why don't you use a pivot table with the table option to split your document by Division and Regional lead ? On 30 août, 06:52, anu gomathi anugomathi.d...@gmail.com wrote: Hi Experts, I am very new to this forum. Attached the details report the out put file. I need a macro to split the workbook as per the below condition: The detail report file should be splitted based on the divisional lead regional lead. Condition 1: while splitting the file summary should be there in the summary sheet. Better the formula would be useful instead of values. Condition2 : The Qtr code Q1 Fy12 details should come in the summary sheet rest all the qtr's should be in details sheet. Please help me in this. Thanks in advance. Regards Anu Detail report.xls 1506KAfficherTélécharger Andy Huntrods-SI Report-010811.xls 104KAfficherTélécharger -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ User form
Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel New Microsoft Office Excel Worksheet (2).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ User form
Hi Prasad, Look attached below... If you want to create some VBA Coding in background of userforms..You have to save the file has a .XLS or XLSM because XLSX wont support Macro Language.. *Best Regards,* *Venkat * *Chennai* On Tue, Aug 30, 2011 at 6:12 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Auto_Open.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ User form
What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub From: Suryaprasad Sent: Tuesday, August 30, 2011 7:42 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ User form
Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.com wrote: What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub *From:* Suryaprasad suryaprasad...@gmail.com *Sent:* Tuesday, August 30, 2011 7:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ User form
Hi Surya, Your excel sheet is empty..Please check.. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.comwrote: What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub *From:* Suryaprasad suryaprasad...@gmail.com *Sent:* Tuesday, August 30, 2011 7:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ help
Hi vijay, Please send some sample data...for your requirement.. *Best Regards,* *Venkat * *Chennai* On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi, i have four words and i need to combine using trim and proper functions. Please can you provide me formula Thank you -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Fwd: $$Excel-Macros$$ User form
Hi Surya, Your excel sheet is empty..Please check..and resend it back...and please Elaborate more about your query. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.comwrote: What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub *From:* Suryaprasad suryaprasad...@gmail.com *Sent:* Tuesday, August 30, 2011 7:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- *Best Regards,* *Venkat * *Chennai* * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ help
Use Concatenate =Concatenate(Proper(Trim(YourWord)), Proper(Trim(YourWord)) Or Sign Proper(Trim(YourWord)) Proper(Trim(YourWord)) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Tuesday, August 30, 2011 7:27 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help Hi, i have four words and i need to combine using trim and proper functions. Please can you provide me formula Thank you -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Named Range to Dynamic with VBA
You can put this in a regular sub or this worksheet double click event Right click sheet tabview codeinsert thisdouble click any cell to name range Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) For Each N In ActiveWorkbook.Names If InStr(1, N.RefersTo, ActiveSheet.Name, vbTextCompare) 0 Then Set X = Intersect(ActiveCell, Range(N.RefersTo)) If Not X Is Nothing Then fc = Range(N).Cells(1, 1).Address mc = Range(N).EntireColumn.Address N.RefersTo = =OFFSET( fc ,,,COUNTA( mc )) End If End If Next N End Sub From: Daniel Sent: Tuesday, August 30, 2011 4:34 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Named Range to Dynamic with VBA Hi, Be cautious with this macro and keep a copy of your workbook. Look at the attached workbook in which there is an example of error. Sub test() Dim N As Name, Var As String, Tabl As Variant For Each N In ActiveWorkbook.Names If LCase(Left(N.RefersTo, 7)) =offset Then Tabl = Split(Right(N.RefersTo, Len(N.RefersTo) - 1), :) Var = Range(Tabl(0)).Resize(, 1).EntireColumn.Address N.RefersTo = =OFFSET( Tabl(0) ,,,COUNTA( Var )) End If Next N End Sub Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Cab Boose Envoyé : lundi 29 août 2011 23:39 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Named Range to Dynamic with VBA Hi I would like to select an already named range and using a command button convert it to dynamic named range by columns and rows. Is this possible ? It would be a lot quicker than doing it manually each time. I failed to make a lot dynamic when I set them up. Appreciate your help, I am aged !! (67) and do part time work just a few hours a week for a small business. Love Excel. Thanks and regards Charlie Harris -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...
Hi Bajrang, You can use sumifs() Function for this I think, or attached a sample file to better understand your Query, Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of B Sharma Sent: Tuesday, August 16, 2011 12:53 PM To: MS EXCEL AND VBA MACROS Cc: rajanverma1...@gmail.com Subject: $$Excel-Macros$$ How to use Multiple criteria in DSUM function... Hello to Excel Experts and other users of this group. I've been looking everywhere about how to put several criteria in different cell ranges in: DSUM(database, field, criteria). I have a very large database and using Dsum and I am using different different criteria in different different columns. Normally you put for example A1:G2 and everything works fine. Now the problem is that I have quite many criterias that are common for several DSUM() and I would like to split the criterias into for example A1:D2 and G1:G2. I've triad DSUM(database, field, {A1:D2, G1:G2}) (cannot use arrays with refernces..), DSUM(database, field, A1:D2, G1:G2) (too many arguments..).. etc. What can I do? If anyone has an idea please let me know !! B. Sharma -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ any short key to remove double add.
Hi NOORAIN ANSARI, Pls tell wat is this.?? if you feel free explain me. Regards V. Kannan Aircel Limited Chennai On Mon, Aug 29, 2011 at 3:38 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Anil, Use Alt+A Q for Advance filter.. Choose *Filter the list-List range-Criteria range-Unique Records only * On Mon, Aug 29, 2011 at 3:06 PM, anil kumar kmr7a...@gmail.com wrote: Dear all, I am attach. file in this file has some add. and some add. are is double, triple, so when i use short key Alt + a,m to remove double, than i do not gate data in proper sequence. plz lead me. Thanks Anil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ any short key to remove double add.
Hi Kannan, In Excel 2007(or)2010 version Having Advanced filter option you can get a unique records by using *Filter the list-List range-Criteria range-Unique Records only * * * *This Option will be used for removing duplicates and unique records viewing Purpuse..* *Best Regards,* *Venkat * *Chennai* On Tue, Aug 30, 2011 at 5:57 PM, kannan excel kannan.ex...@gmail.comwrote: Hi NOORAIN ANSARI, Pls tell wat is this.?? if you feel free explain me. Regards V. Kannan Aircel Limited Chennai On Mon, Aug 29, 2011 at 3:38 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Anil, Use Alt+A Q for Advance filter.. Choose *Filter the list-List range-Criteria range-Unique Records only * On Mon, Aug 29, 2011 at 3:06 PM, anil kumar kmr7a...@gmail.com wrote: Dear all, I am attach. file in this file has some add. and some add. are is double, triple, so when i use short key Alt + a,m to remove double, than i do not gate data in proper sequence. plz lead me. Thanks Anil -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ help
Dear Vijay, if your Word in one cell you can use... =PROPER(Trim(SUBSTITUTE(D4, ,))) On Tue, Aug 30, 2011 at 7:26 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi, i have four words and i need to combine using trim and proper functions. Please can you provide me formula Thank you -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ User form
Hi Venkat, Sorry for the wrong attachment, here is the updated one. What i need is when i open the spread sheet the form should POP automatically. Thanks Prasad. On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV venkat1@gmail.com wrote: Hi Surya, Your excel sheet is empty..Please check.. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.comwrote: What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub *From:* Suryaprasad suryaprasad...@gmail.com *Sent:* Tuesday, August 30, 2011 7:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel User.xlsm Description: Binary data
Re: $$Excel-Macros$$ User form
Dear surya, Please see attached sheet.. On Tue, Aug 30, 2011 at 9:00 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi Venkat, Sorry for the wrong attachment, here is the updated one. What i need is when i open the spread sheet the form should POP automatically. Thanks Prasad. On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV venkat1@gmail.com wrote: Hi Surya, Your excel sheet is empty..Please check.. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.comwrote: What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub *From:* Suryaprasad suryaprasad...@gmail.com *Sent:* Tuesday, August 30, 2011 7:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on
$$Excel-Macros$$ How to load data into Combo box in user form
Hi All, Attached is the sheet where i need the list of the countries to be added to the combo box Note : The Combo box should be enabled once the data is entered in Text Box given above of Combo box. Please do the needfull. Thanks Prasad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Combo.xlsm Description: Binary data
Re: $$Excel-Macros$$ How to load data into Combo box in user form
Go to Property of Combo box type the Range under the row source of Combobox.: On Tue, Aug 30, 2011 at 9:09 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi All, Attached is the sheet where i need the list of the countries to be added to the combo box Note : The Combo box should be enabled once the data is entered in Text Box given above of Combo box. Please do the needfull. Thanks Prasad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Rakesh Joshi -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ How to load data into Combo box in user form
See the attached From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rakesh Joshi Sent: Tuesday, August 30, 2011 9:29 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to load data into Combo box in user form Go to Property of Combo box type the Range under the row source of Combobox.: On Tue, Aug 30, 2011 at 9:09 PM, Suryaprasad suryaprasad...@gmail.com wrote: Hi All, Attached is the sheet where i need the list of the countries to be added to the combo box Note : The Combo box should be enabled once the data is entered in Text Box given above of Combo box. Please do the needfull. Thanks Prasad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Rakesh Joshi -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Combo.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Calculate Product Sold To Date by Product
Your help please. I have a log of product sold and need to calculate the different product sold to date, like a running accumulation field specific to product listed in column B. Please see my attached spreadsheet. Thanking you in advance for all your great help. John -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Accumulated Balance by Date.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003
Dear All, Do we have any option for countifs Sumifs formula in MS Excel 2003? Best Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003
=sumproduct((a2:a22=1)*b2:b22) From: Amit Desai (MERU) Sent: Tuesday, August 30, 2011 11:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 Dear All, Do we have any option for countifs Sumifs formula in MS Excel 2003? Best Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003
What about option for countifS? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Tuesday, August 30, 2011 10:04 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 =sumproduct((a2:a22=1)*b2:b22) From: Amit Desai (MERU)mailto:amit.de...@merucabs.com Sent: Tuesday, August 30, 2011 11:24 AM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 Dear All, Do we have any option for countifs Sumifs formula in MS Excel 2003? Best Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003
=sumproduct((a2:a22=1)*(b2:b22)) From: Amit Desai (MERU) Sent: Tuesday, August 30, 2011 12:03 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 What about option for countifS? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Tuesday, August 30, 2011 10:04 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 =sumproduct((a2:a22=1)*b2:b22) From: Amit Desai (MERU) Sent: Tuesday, August 30, 2011 11:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 Dear All, Do we have any option for countifs Sumifs formula in MS Excel 2003? Best Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @
Re: $$Excel-Macros$$ How to load data into Combo box in user form
Hi Rajan, Thanks for the attachment, but my requirement is to add the list in the Userform provided in excel sheet not on the excel spread sheet. Note : The Combo box should be enabled once the data is entered in Text Box given above of Combo box. Please do the needfull. Thanks Prasad On Tue, Aug 30, 2011 at 9:33 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *See the attached * * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Rakesh Joshi *Sent:* Tuesday, August 30, 2011 9:29 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ How to load data into Combo box in user form ** ** Go to Property of Combo box type the Range under the row source of Combobox.: On Tue, Aug 30, 2011 at 9:09 PM, Suryaprasad suryaprasad...@gmail.com wrote: Hi All, Attached is the sheet where i need the list of the countries to be added to the combo box Note : The Combo box should be enabled once the data is entered in Text Box given above of Combo box. Please do the needfull. Thanks Prasad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel ** ** -- Rakesh Joshi -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003
But what if I need a count ( not sum)of numbers in a cell? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Tuesday, August 30, 2011 10:41 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 =sumproduct((a2:a22=1)*(b2:b22)) From: Amit Desai (MERU)mailto:amit.de...@merucabs.com Sent: Tuesday, August 30, 2011 12:03 PM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 What about option for countifS? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Tuesday, August 30, 2011 10:04 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 =sumproduct((a2:a22=1)*b2:b22) From: Amit Desai (MERU)mailto:amit.de...@merucabs.com Sent: Tuesday, August 30, 2011 11:24 AM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 Dear All, Do we have any option for countifs Sumifs formula in MS Excel 2003? Best Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ How to load data into Combo box in user form
See the attached Sheet.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rakesh Joshi Sent: Tuesday, August 30, 2011 9:29 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to load data into Combo box in user form Go to Property of Combo box type the Range under the row source of Combobox.: On Tue, Aug 30, 2011 at 9:09 PM, Suryaprasad suryaprasad...@gmail.com wrote: Hi All, Attached is the sheet where i need the list of the countries to be added to the combo box Note : The Combo box should be enabled once the data is entered in Text Box given above of Combo box. Please do the needfull. Thanks Prasad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Rakesh Joshi -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Combo.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003
TRY it!!! From: Amit Desai (MERU) Sent: Tuesday, August 30, 2011 12:18 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 But what if I need a count ( not sum)of numbers in a cell? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Tuesday, August 30, 2011 10:41 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 =sumproduct((a2:a22=1)*(b2:b22)) From: Amit Desai (MERU) Sent: Tuesday, August 30, 2011 12:03 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 What about option for countifS? Best Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Tuesday, August 30, 2011 10:04 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 =sumproduct((a2:a22=1)*b2:b22) From: Amit Desai (MERU) Sent: Tuesday, August 30, 2011 11:24 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 Dear All, Do we have any option for countifs Sumifs formula in MS Excel 2003? Best Regards, Amit Desai Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials
Re: $$Excel-Macros$$ Calculate Product Sold To Date by Product
Thank you very much for your quick response, your patience and your help. John On Tue, Aug 30, 2011 at 12:37 PM, dguillett1 dguille...@gmail.com wrote: in d2 copied down =SUMIF($B$2:B2,B2,$C$2:C2) *From:* John A. Smith johnasmit...@gmail.com *Sent:* Tuesday, August 30, 2011 11:09 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Calculate Product Sold To Date by Product Your help please. I have a log of product sold and need to calculate the different product sold to date, like a running accumulation field specific to product listed in column B. Please see my attached spreadsheet. Thanking you in advance for all your great help. John -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Need macro to split the files
Please attach file 2011/8/30 anu gomathi anugomathi.d...@gmail.com Hi, Can u pls explain me the steps. Any way i need the summary in the detail sheet. Regards Anu On Tue, Aug 30, 2011 at 2:52 PM, Frederic LE GUEN - MVP Excel fleg...@gmail.com wrote: Why don't you use a pivot table with the table option to split your document by Division and Regional lead ? On 30 août, 06:52, anu gomathi anugomathi.d...@gmail.com wrote: Hi Experts, I am very new to this forum. Attached the details report the out put file. I need a macro to split the workbook as per the below condition: The detail report file should be splitted based on the divisional lead regional lead. Condition 1: while splitting the file summary should be there in the summary sheet. Better the formula would be useful instead of values. Condition2 : The Qtr code Q1 Fy12 details should come in the summary sheet rest all the qtr's should be in details sheet. Please help me in this. Thanks in advance. Regards Anu Detail report.xls 1506KAfficherTélécharger Andy Huntrods-SI Report-010811.xls 104KAfficherTélécharger -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Need macro to split the files
Hi I have written today a page about the way to create a worksheet function of a criteria http://www.excel-exercice.com/en/2074/creation-of-worksheets-by-criteria I'm sure that this tip will help you ;) On 30 août, 06:52, anu gomathi anugomathi.d...@gmail.com wrote: Hi Experts, I am very new to this forum. Attached the details report the out put file. I need a macro to split the workbook as per the below condition: The detail report file should be splitted based on the divisional lead regional lead. Condition 1: while splitting the file summary should be there in the summary sheet. Better the formula would be useful instead of values. Condition2 : The Qtr code Q1 Fy12 details should come in the summary sheet rest all the qtr's should be in details sheet. Please help me in this. Thanks in advance. Regards Anu Detail report.xls 1506KAfficherTélécharger Andy Huntrods-SI Report-010811.xls 104KAfficherTélécharger -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Need macro to split the files
I have also created thousands of functions, and PivotTables you're asking or you're selling web site? 2011/8/30 Frederic LE GUEN - MVP Excel fleg...@gmail.com Hi I have written today a page about the way to create a worksheet function of a criteria http://www.excel-exercice.com/en/2074/creation-of-worksheets-by-criteria I'm sure that this tip will help you ;) On 30 août, 06:52, anu gomathi anugomathi.d...@gmail.com wrote: Hi Experts, I am very new to this forum. Attached the details report the out put file. I need a macro to split the workbook as per the below condition: The detail report file should be splitted based on the divisional lead regional lead. Condition 1: while splitting the file summary should be there in the summary sheet. Better the formula would be useful instead of values. Condition2 : The Qtr code Q1 Fy12 details should come in the summary sheet rest all the qtr's should be in details sheet. Please help me in this. Thanks in advance. Regards Anu Detail report.xls 1506KAfficherTélécharger Andy Huntrods-SI Report-010811.xls 104KAfficherTélécharger -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ User form
Hi Surya, Try the Below... *Private Sub Workbook_Open()* *UserForm1.show* *End Sub* *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 9:00 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi Venkat, Sorry for the wrong attachment, here is the updated one. What i need is when i open the spread sheet the form should POP automatically. Thanks Prasad. On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV venkat1@gmail.com wrote: Hi Surya, Your excel sheet is empty..Please check.. *Best Regards,* *Venkat * *Chennai* * * * * On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad suryaprasad...@gmail.comwrote: Hi , Please see my excel spread sheet i need the userform as POP see the chail mail Thanks Prasad On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 dguille...@gmail.comwrote: What userform? Put this in the ThisWorkbook module Private Sub Workbook_Open() nameofyouruserformhere.Show End Sub *From:* Suryaprasad suryaprasad...@gmail.com *Sent:* Tuesday, August 30, 2011 7:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ User form Hi All, Need a small help , i need to get a pop up of the user form when my excel is opened, see the attachment Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just
Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003
Hi Amit See below link for Sumifs in 2003 http://chandoo.org/forums/topic/converting-sumifs-to-excel-2003 -- *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 9:54 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Dear All, ** ** Do we have any option for countifs Sumifs formula in MS Excel 2003? ** ** Best Regards, Amit Desai ** ** -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Calculate Product Sold To Date by Product
Hi john, Try the Below... =SUMIF($B$2:$B$8,B2,$D$2:$D$8) *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 9:39 PM, John A. Smith johnasmit...@gmail.comwrote: Your help please. I have a log of product sold and need to calculate the different product sold to date, like a running accumulation field specific to product listed in column B. Please see my attached spreadsheet. Thanking you in advance for all your great help. John -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...
Yes Rajan, You are right I am using the same for the time being... but I wanted to use this through Dsum... anyways ... thanks for your time... On Aug 30, 7:32 pm, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Bajrang, You can use sumifs() Function for this I think, or attached a sample file to better understand your Query, Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of B Sharma Sent: Tuesday, August 16, 2011 12:53 PM To: MS EXCEL AND VBA MACROS Cc: rajanverma1...@gmail.com Subject: $$Excel-Macros$$ How to use Multiple criteria in DSUM function... Hello to Excel Experts and other users of this group. I've been looking everywhere about how to put several criteria in different cell ranges in: DSUM(database, field, criteria). I have a very large database and using Dsum and I am using different different criteria in different different columns. Normally you put for example A1:G2 and everything works fine. Now the problem is that I have quite many criterias that are common for several DSUM() and I would like to split the criterias into for example A1:D2 and G1:G2. I've triad DSUM(database, field, {A1:D2, G1:G2}) (cannot use arrays with refernces..), DSUM(database, field, A1:D2, G1:G2) (too many arguments..).. etc. What can I do? If anyone has an idea please let me know !! B. Sharma -- --- - -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Attach file for discussion
How can I attach a spreadsheet for review? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Macro to remove repeats and merge
I have the following: Column A B C D E F 12722 12722 51.564.89 RNLOX 12723 12723 51.564.89 RNLOX Would you have the solution to replace B1 by B2 and delete row 2 once completed since they have been merge? Thanks, G. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Decimal greater than 0.5
Hi All, How to convert the numbers in a column based on following: example: 13.45 should be displayed as 13 13.5 or 13.51(decimal equal or greater than .5) should be 14. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Macro to remove repeats and merge
Hi, You can try Remove duplicate's option in Excel 2007 or 2010 use ALT+A+T *Best Regards,* *Venkat * *Chennai* On Wed, Aug 31, 2011 at 2:44 AM, Gaetan M gaetan.me...@wanadoo.fr wrote: I have the following: Column A B C D E F 12722 12722 51.564.89 RNLOX 12723 12723 51.564.89 RNLOX Would you have the solution to replace B1 by B2 and delete row 2 once completed since they have been merge? Thanks, G. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Attach file for discussion
Hi, In your G mail Just click Compose Mail and attach and write your query and send it to *excel-macros@googlegroups.com* *Best Regards,* *Venkat * *Chennai* On Wed, Aug 31, 2011 at 2:47 AM, Tripp ken...@gmxresources.com wrote: How can I attach a spreadsheet for review? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Decimal greater than 0.5
Hi, try Round formula Example Below =ROUND(A1,0) *Best Regards,* *Venkat * *Chennai* * * On Tue, Aug 30, 2011 at 10:54 PM, Skanda skanda.pokkun...@gmail.com wrote: Hi All, How to convert the numbers in a column based on following: example: 13.45 should be displayed as 13 13.5 or 13.51(decimal equal or greater than .5) should be 14. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Combox List in Userform
Hi All, Attached is the sheet where i need the data to be loaded Combo box of the userform given, i need a VBA Code which picks the data from the excel spread sheet and provides them in the combo box as a drop down list..please help Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Country.xlsm Description: Binary data
RE: $$Excel-Macros$$ Combox List in Userform
See attached file.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mr Excellent Sent: Wednesday, August 31, 2011 10:20 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Combox List in Userform Hi All, Attached is the sheet where i need the data to be loaded Combo box of the userform given, i need a VBA Code which picks the data from the excel spread sheet and provides them in the combo box as a drop down list..please help Thanks Prasad. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Copy of Country.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
RE: $$Excel-Macros$$ Decimal greater than 0.5
You can also use this : =MROUND(B5,1) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Sent: Wednesday, August 31, 2011 10:07 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Decimal greater than 0.5 Hi, try Round formula Example Below =ROUND(A1,0) Best Regards, Venkat Chennai On Tue, Aug 30, 2011 at 10:54 PM, Skanda skanda.pokkun...@gmail.com wrote: Hi All, How to convert the numbers in a column based on following: example: 13.45 should be displayed as 13 13.5 or 13.51(decimal equal or greater than .5) should be 14. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ How to use Multiple criteria in DSUM function...
Sir ji EK sample file attached Kar do .. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of B Sharma Sent: Wednesday, August 31, 2011 9:24 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ How to use Multiple criteria in DSUM function... Yes Rajan, You are right I am using the same for the time being... but I wanted to use this through Dsum... anyways ... thanks for your time... On Aug 30, 7:32 pm, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Bajrang, You can use sumifs() Function for this I think, or attached a sample file to better understand your Query, Rajan. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of B Sharma Sent: Tuesday, August 16, 2011 12:53 PM To: MS EXCEL AND VBA MACROS Cc: rajanverma1...@gmail.com Subject: $$Excel-Macros$$ How to use Multiple criteria in DSUM function... Hello to Excel Experts and other users of this group. I've been looking everywhere about how to put several criteria in different cell ranges in: DSUM(database, field, criteria). I have a very large database and using Dsum and I am using different different criteria in different different columns. Normally you put for example A1:G2 and everything works fine. Now the problem is that I have quite many criterias that are common for several DSUM() and I would like to split the criterias into for example A1:D2 and G1:G2. I've triad DSUM(database, field, {A1:D2, G1:G2}) (cannot use arrays with refernces..), DSUM(database, field, A1:D2, G1:G2) (too many arguments..).. etc. What can I do? If anyone has an idea please let me know !! B. Sharma -- --- - -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ stock on hand report generate
Hi all experts i have a small store which contains 300 products( MEDICINES).in a quarter i reviced the items once or twice.But i issue items to various dept twice in a week or thrice in fortnight.My requirement is 1.on item recieved to my store i enter all items in reciept colum.The qty should add the previous balance 2. if i issue the qty should deduct. 3 on end of the month stock on hand report shoud generte to print ( if it possibe with expiry date). Please help me in excel is it possibel with vba code Like Reciepts, Issues,Reports, Departments(to select which i issue) user form. and data management information . thanks in advance -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003
See the attached From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkat CV Sent: Wednesday, August 31, 2011 7:33 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Option for countifs Sumifs formula in MS Excel 2003 Hi Amit See below link for Sumifs in 2003 http://chandoo.org/forums/topic/converting-sumifs-to-excel-2003 -- Best Regards, Venkat Chennai On Tue, Aug 30, 2011 at 9:54 PM, Amit Desai (MERU) amit.de...@merucabs.com wrote: Dear All, Do we have any option for countifs Sumifs formula in MS Excel 2003? Best Regards, Amit Desai _ Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Book1.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12