Re: $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION
Dear Sir, thanks for help. i am already woking with index/match fourmula. i want macro function to solve. On Fri, May 4, 2012 at 10:49 AM, Deepak Rawat deepakexce...@gmail.comwrote: Hi Pls find the attached. I used formula instead of Macro. Regards, Deepak Rawat On Thu, May 3, 2012 at 9:33 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: DEAR SIR, PLZ DOWNLOAD THE ATTACHED FILE AND GIVE THE CODE FOR CREATING FUNCTION TO CALCULATE WEIGHT AGE AND GRADE Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days
Dear All, I need date formula for finding how many days and months between two different dates. Request you to resolve my query. I have attached is the same file. Regards, Vijayendra 94491 67631 -- ಧನ್ಯವಾದಗಳು, ವಿಜಯೇಂದ್ರ, ೯೪೪೯೧ ೬೭೬೩೧ Regards, Vijayendra 94491 67631 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Date related.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ $$Excel-Macros$$ $$Excel-Macros$$ Formula Need for difference between days
*Hi *Vijay, You can you try formula, it will help you out.:- For Date diffrence:- =DATEDIF(A2,(B2),md) For Month diffrence :- =DATEDIF(A2,(B2),ym) For Year diffrence :- =DATEDIF(A2,(B2),y) Thanks Regards,* * *Deba Ranjan P*** On Fri, May 4, 2012 at 12:39 PM, Vijayendra Rao vijayendrar...@gmail.comwrote: Dear All, I need date formula for finding how many days and months between two different dates. Request you to resolve my query. I have attached is the same file. Regards, Vijayendra 94491 67631 -- ಧನ್ಯವಾದಗಳು, ವಿಜಯೇಂದ್ರ, ೯೪೪೯೧ ೬೭೬೩೧ Regards, Vijayendra 94491 67631 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012
Hi Experts, After a long time again Rajan verma has come back. All the best my friend. Keep rocking !!! Regards Lokesh.M On Wed, May 2, 2012 at 9:30 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of April'2012 He has posted 185 posts in April 2012 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived this recognition many times. Thanks to Don, Noorain, Asa, Maries, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012
Congratulation Rajan and other excel's mentors. Regards, Ankit On Wed, May 2, 2012 at 9:30 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of April'2012 He has posted 185 posts in April 2012 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived this recognition many times. Thanks to Don, Noorain, Asa, Maries, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012
*Congrats Rajan Shahab, And Thanks every member of Excel forum who have devoted their times in analytical for solving problem and vice versa. * Thanks Regards,* * *Deba Ranjan P*** On Fri, May 4, 2012 at 2:45 PM, Ankit Agrawal ankit.agrawal...@gmail.comwrote: Congratulation Rajan and other excel's mentors. Regards, Ankit On Wed, May 2, 2012 at 9:30 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of April'2012 He has posted 185 posts in April 2012 and helped many people through his expertise. He has been consistent contributor to this excel forum and has acheived this recognition many times. Thanks to Don, Noorain, Asa, Maries, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Chart-Secondary Axis option
Hi Hilary, Please try it.. http://www.andypope.info/tips/tip008.htm -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, May 3, 2012 at 10:05 PM, hilary lomotey resp...@gmail.com wrote: Hello Gurus, For some reason when i right click in the attached file(bar chart) and click on format data series and i want to turn on the secondary axis option(from the plot series on) in the series option it looks faded out, pls how do i turn it on? thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Re: Help me to generate Report
More infos , less gibberish please. On Friday, May 4, 2012 11:30:18 AM UTC+3, ankit wrote: Dear all, I have some data in one sheet and I have to generate report which format is also on second sheet. How can we generate it. Thanks Regards, Ankit -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Split file individually -Need macro
Yes ..we always need at least on loop, but this code is avoiding loop to find One By One unique value in that particular column then copy the entire Row of matching cell in on another workbook.. Filter Data with a Loop is Good approach to do that thing. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: 04 May 2012 00:12 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Split file individually -Need macro Yeah, I don't see how you can avoid a loop (with many files to create). However, you could do some optimization to avoid copying the whole table to another range, removing the duplicates, then having to clean all that up, along these lines: SRC_RANGE.AdvancedFilter xlfilterinplace, unique:=true UniqueValuesArray = SRC_RANGE.SpecialCells(xlcelltypevisible).value2 SRC_SHEET.ShowAllData For Each UniqueValue in UniqueValuesArray 'filter for value 'copy to new WB 'save new WB Next UniqueValue Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Thursday, May 03, 2012 7:33 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Split file individually -Need macro But not manually if you have many unique values.. Macro is only for saving time Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 03 May 2012 19:55 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Split file individually -Need macro This is a a better approach than looping Filtercopy visible to new workbooksave as close Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Rajan_Verma mailto:rajanverma1...@gmail.com Sent: Thursday, May 03, 2012 8:27 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Split file individually -Need macro Hi Try the Blow Code to Split Date with in multiple workbook Please find the attached File Sub SplitAllbyCode() Dim rngRangeAs Range Dim wksSheetAs Worksheet Dim ArrUniqe Dim lngUniqeCount As Long Dim wbkNew As Workbook Set wksSheet = ThisWorkbook.Worksheets(Sheet1) With wksSheet Set rngRange = Intersect(Range(rngStart).CurrentRegion, Range(rngStart).CurrentRegion.Offset(2)) Application.ScreenUpdating = False rngRange.Columns(4).Copy Range(rngRemoveDuplicate) Range(rngRemoveDuplicate).CurrentRegion.RemoveDuplicates 1 ArrUniqe = Range(rngRemoveDuplicate).CurrentRegion For lngUniqeCount = LBound(ArrUniqe) To UBound(ArrUniqe) Range(rngStart).CurrentRegion.Rows(2).AutoFilter 4, ArrUniqe(lngUniqeCount, 1) Range(rngStart).CurrentRegion.SpecialCells(xlCellTypeVisible).Copy Set wbkNew = Workbooks.Add wbkNew.Worksheets(1).Paste wbkNew.SaveAs ThisWorkbook.Path \ ArrUniqe(lngUniqeCount, 1) wbkNew.Close 1 Next lngUniqeCount End With wksSheet.AutoFilterMode = False Application.ScreenUpdating = True Range(rngRemoveDuplicate).CurrentRegion.ClearContents MsgBox lngUniqeCountFiles has been splited, Plase find your files at vbCrLf ThisWorkbook.Path 'Free Memory Set rngRange = Nothing Set wksSheet = Nothing Erase ArrUniqe Set wbkNew = Nothing End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 03 May 2012 15:12 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Split file individually -Need macro Dear Murali, Please see attached sheet, Hope it will useful to you. Kindly change path in the code then run. Wait 5 minute after run the program. -- Thanks regards, Noorain Ansari www.noorainansari.com http://www.noorainansari.com/ http://www.excelmacroworld.blogspot.com/ www.excelmacroworld.blogspot.com On Thu, May 3, 2012 at 2:19 PM, MURALI NAGARAJAN muralin...@gmail.com wrote: Dear experts. We want to split the data individually and the same file should save individually ascode name in new folder(Desktop/My document). Thanks in advance. Thanks@Regards Murali.N Chennai -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive
Re: $$Excel-Macros$$ help Pls for creating graph,
Without too much looking it should be easy enough to fill in your source data cells using formulas for A,B,C, etc. and use ONE chart that changes with a change in name.. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com -Original Message- From: Harkesh Kumar Sent: Friday, May 04, 2012 3:07 AM To: NOORAIN ANSARI ; rajanverma1987 ; dguillett1 ; excel-macros Subject: $$Excel-Macros$$ help Pls for creating graph, Dear experts. Please help for creating graphs of multipls person. please help.. -- Forwarded message -- From: Harkesh Kumar harkesh.kuma...@gmail.com Date: Fri, 4 May 2012 12:10:22 +0530 Subject: help Pls To: NOORAIN ANSARI noorain.ans...@gmail.com, rajanverma1...@gmail.com, dguille...@gmail.com Hi, we need to create Graph on the base of row data same graph we required person wise . please help me for the same. and if we can create better graph pls suggest. thanx Harkesh -- Hi, Thanks for your mail.I will revert you asap Ragards -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Multi Combo Box
Hello, Thanks all. Regards, Chandra Shekar B On Wed, May 2, 2012 at 6:56 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: 2012/5/2 Rajan_Verma rajanverma1...@gmail.com Hi Chandru Please find the attached sheet, you can use list validation for that..*** * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar *Sent:* 02 May 2012 13:13 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Multi Combo Box ** ** Hello, Could you please help me on the attached file. Thanks in advance. Regards, Chandra Shekar B On Tue, May 1, 2012 at 3:39 PM, Rajan_Verma rajanverma1...@gmail.com wrote: *HI Chandru,* * * *File size will be very larege with 1000 controlls on worksheet.. I suggest to use List Validation on each cell in your range* * * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar *Sent:* 01 May 2012 18:53 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Multi Combo Box Hello, I would like to have multi combo box on every row (1000 rows). Could you please help me out on this. Thanks in advance. Regards, Chandra Shekar B -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com ** ** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to
Re: $$Excel-Macros$$ Chart-Secondary Axis option
Hi, Another solution Try these links http://office.microsoft.com/en-us/excel-help/add-or-remove-a-secondary-axis-in-a-chart-HP001234165.aspx http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation*https://www.facebook.com/buzinesstransformation On Fri, May 4, 2012 at 4:03 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Hilary, Please try it.. http://www.andypope.info/tips/tip008.htm -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, May 3, 2012 at 10:05 PM, hilary lomotey resp...@gmail.com wrote: Hello Gurus, For some reason when i right click in the attached file(bar chart) and click on format data series and i want to turn on the secondary axis option(from the plot series on) in the series option it looks faded out, pls how do i turn it on? thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Chart-Secondary Axis option
hai friends, I would like to learn Excel basics. Can anyone please provide me with notes and examples. Regards, Kishore -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Code for range shifting based on month
see if it helps cell c3 enter this formula =SUMPRODUCT(--($A$104:$A$65536=DATE(LEFT($A3,4),RIGHT($A3,2),1)),--($A$104:$A$65536DATE(LEFT($A3,4),RIGHT($A3,2)+1,1)),--($B$104:$B$65536=$B3)*(C$104:C$65536)) On Thu, May 3, 2012 at 12:11 PM, Darwin Chan darwin.chankaw...@gmail.comwrote: Dear all, I have a spreadsheet containing daily customer transaction data. I have used SUMIF to find out the monthly customer transaction data. However, it is tedious to copy the formula and paste for next month when next month comes. Can anyone suggest any VBA code / idea to help shifting the formula? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION
DEAR SIR THANKS TO ALL. I HAVE DONE IT. THIS IS MY FIRST SMALL VBA PRG. I HAVE LEARN VBA FROM THIS GROUP. On Fri, May 4, 2012 at 6:34 PM, dguillett1 dguille...@gmail.com wrote: Then, one way is to apply the formula using a macro and then change to value if desired. Or, use EVALUATE for the formula. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Sourabh Salgotra rhtdmja...@gmail.com *Sent:* Friday, May 04, 2012 1:03 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION Dear Sir, thanks for help. i am already woking with index/match fourmula. i want macro function to solve. On Fri, May 4, 2012 at 10:49 AM, Deepak Rawat deepakexce...@gmail.comwrote: Hi Pls find the attached. I used formula instead of Macro. Regards, Deepak Rawat On Thu, May 3, 2012 at 9:33 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: DEAR SIR, PLZ DOWNLOAD THE ATTACHED FILE AND GIVE THE CODE FOR CREATING FUNCTION TO CALCULATE WEIGHT AGE AND GRADE Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ Rounding value of six digit
Hi please explain because the rounding of a number is based on some rules. *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation*https://www.facebook.com/buzinesstransformation On Fri, May 4, 2012 at 8:48 PM, Shekhar Sharma shekhar1...@gmail.comwrote: Hi Experts, Kindly help me with rounding a value of six digit. Example: Cell A1 has value as : 59687 I want a formula available in excel to convert this value into 59000. I have used =ROUND(A1/1000,0)*1000, however its not a perfect way to convert this value. Let me know if you are aware of any typical formula available with in excel. -- Shekhar Sharma 9910010060 Life consists not in holding good cards but in playing those you hold well Before you judge another, think of your own last mistake. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Rounding value of six digit
Or you can use this =INT(ROUND(A1/1000,3))*1000 *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation*https://www.facebook.com/buzinesstransformation On Fri, May 4, 2012 at 10:11 PM, ╰» ℓαℓιт мσαнη mohan.pande...@gmail.comwrote: Hi please explain because the rounding of a number is based on some rules. *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation*https://www.facebook.com/buzinesstransformation On Fri, May 4, 2012 at 8:48 PM, Shekhar Sharma shekhar1...@gmail.comwrote: Hi Experts, Kindly help me with rounding a value of six digit. Example: Cell A1 has value as : 59687 I want a formula available in excel to convert this value into 59000. I have used =ROUND(A1/1000,0)*1000, however its not a perfect way to convert this value. Let me know if you are aware of any typical formula available with in excel. -- Shekhar Sharma 9910010060 Life consists not in holding good cards but in playing those you hold well Before you judge another, think of your own last mistake. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Help Required to update off days in a tracker
Dear Vaseema, Please see attached workbook, Hope it will help to you. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Fri, May 4, 2012 at 11:29 AM, Seema vasee...@gmail.com wrote: hello, i am using a form as a user interface for an employee to enter the off day of their choice week on week. i want to update the tracker based on the entries from the combobox. Attached is the sample file with the entry format. Any help is highly apprecaited. Regards Seema -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Tracker (Solved).xlsm Description: Binary data
Re: $$Excel-Macros$$ Chart-Secondary Axis option
Try these link also www.nios.ac.in/basiccomp/l12.pdf http://mac2.microsoft.com/help/office/14/en-us/excel/item/301ec775-d4b3-452d-85af-55df53ff6db8 *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation*https://www.facebook.com/buzinesstransformation On Fri, May 4, 2012 at 10:56 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: PFA On Fri, May 4, 2012 at 7:59 PM, Sweet Kishore kishore...@gmail.comwrote: hai friends, I would like to learn Excel basics. Can anyone please provide me with notes and examples. Regards, Kishore -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Macro to update cells based on values from multiple combobox
Hi Seema, See attachment On Fri, May 4, 2012 at 8:40 PM, Seema vasee...@gmail.com wrote: Hello, Please help in getting a macro for the problem in the sheet attached. Regards Seema. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Tracker (Solved).xlsm Description: Binary data
Re: $$Excel-Macros$$ Help Required to update off days in a tracker
hi, thank you for the effort. but the sheet is not getting updated instead throws an error asking to debug at line15. also, please let me know the logic applied here. Regards On Friday, 4 May 2012 22:51:29 UTC+5:30, NOORAIN ANSARI wrote: Dear Vaseema, Please see attached workbook, Hope it will help to you. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Fri, May 4, 2012 at 11:29 AM, Seema vasee...@gmail.com wrote: hello, i am using a form as a user interface for an employee to enter the off day of their choice week on week. i want to update the tracker based on the entries from the combobox. Attached is the sample file with the entry format. Any help is highly apprecaited. Regards Seema -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Require VBA examples and notes on VBA 2007
Thank you lalit On Fri, May 4, 2012 at 7:36 PM, ╰» ℓαℓιт мσαнη mohan.pande...@gmail.comwrote: Hi, You can also try these links http://www.excel-vba-easy.com/ http://www.youtube.com/watch?v=wH03Xnr3Pug http://www.vbtutor.net/vb.html *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation*https://www.facebook.com/buzinesstransformation On Fri, May 4, 2012 at 8:52 AM, venkat1@gmail.com wrote: Hi noorain, really useful one. Regards, venkat Chennai -- Sent from my Nokia phone --Original message-- From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Date: Thursday, May 3, 2012 11:53:00 PM GMT+0530 Subject: Re: $$Excel-Macros$$ Require VBA examples and notes on VBA 2007 Dear Aruna, Please find attached Basic note of VBA with example. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, May 3, 2012 at 11:41 PM, Aruna jayaram aruna2...@gmail.com wrote: Hi I would like to learn VBA from basics and Macros. Can anyone provide me with notes and examples, macros examples for 2007. Thank you Aruna -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member.
Re: $$Excel-Macros$$ Help Required to update off days in a tracker
i have made some changes in Noorain's code :) [?] PFA *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation*https://www.facebook.com/buzinesstransformation On Fri, May 4, 2012 at 11:16 PM, Seema vasee...@gmail.com wrote: hi, thank you for the effort. but the sheet is not getting updated instead throws an error asking to debug at line15. also, please let me know the logic applied here. Regards On Friday, 4 May 2012 22:51:29 UTC+5:30, NOORAIN ANSARI wrote: Dear Vaseema, Please see attached workbook, Hope it will help to you. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.**comhttp://www.excelmacroworld.blogspot.com/ On Fri, May 4, 2012 at 11:29 AM, Seema vasee...@gmail.com wrote: hello, i am using a form as a user interface for an employee to enter the off day of their choice week on week. i want to update the tracker based on the entries from the combobox. Attached is the sample file with the entry format. Any help is highly apprecaited. Regards Seema -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --**--** --** To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com 330.gif Tracker (Solved).xlsm Description: Binary data
$$Excel-Macros$$ Macro required to add demand to substitution part and zero out the original one, see attachment.
Hello, I have a file for the forecast demand, some parts have substitution, what I need is if the part has substitution, the original demand will be added to the new part and original demand will be zero out, please see the attached file for reference. Thanks, Tony -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com substituation sample.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need macro to verify part numbers between 2 sheets
Hi Larit, I tried the macro on a 2500 lines report, it took long time to proceed and reported error, stopped at: ThisWorkbook.Worksheets(Item Master).Range(A1).End(xlDown).Offset(1).Resize(UBound(varShee1Data) + 1) = Application.Transpose(varShee1Data) Can you please help? Thanks, Tony On Friday, May 4, 2012 10:20:48 AM UTC-4, Tony Wu wrote: It works, thanks a lot!!! On Friday, May 4, 2012 10:02:25 AM UTC-4, Lalit_Mohan wrote: Hi PFA *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation*https://www.facebook.com/buzinesstransformation On Fri, May 4, 2012 at 12:52 AM, Tony Wu wumu...@gmail.com wrote: Hello, I have 2 sheets in one file, one sheet A has less part numbers than the other sheet B, would like to have a macro to verify the part number in A vs. B, anything missing in B will be added to the bottom of sheet A. My logical is trying to use iserror(vlookup(...),0) to see if the logical is false, if so, copy the cell value to sheet A, but don;t know how to translate that into VBA language ... Need your help. Thanks, Tony -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?
Hi All, Can we calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? Can anyone have Typing Practice kind of Macro in Excel, through that we can measure our typing speed? If anyone have this kind of thing then please send me the same. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com