$$Excel-Macros$$ Re: treeview
Sorry, I don't really understand your point. I realise VSTO will be the way to go, I don't really have many issues with that. My point is that I pay MS a lot of money, as do my clients. Solutions have been built in good faith that MS will maintain backwards compatibility, and they are effectively costing myself, and my clients a lot of money - to redevelop solutions, because they don't want to make their new products wholly backwards compatible. I consider that irresponsible and pretty bad in terms of customer service. What argument is there for not making it backwards compatible so existing solutions continue to work? to force all devlopers and clients to buy Visual Studio and redevelop all their existing VBA solutions? Is that not some kind of con? On Sunday, 9 September 2012 14:44:51 UTC+1, bpascal123 wrote: At some point, developing for Office requires access to Visual Studio full package or alternative equivalent tools. I don't think it's about killing VBA for VSTO, I would see this more like setting or defining a border between Office custom solution and Office professional solution. It makes sense, MS wants to keep a hand on major widely used products. To me, as I can't access Visual Studio or other equivalent application for developers, I would look for open source solutions where I can implement a solution that can access system resources and properties... On Saturday, September 8, 2012 10:27:24 AM UTC+1, james D wrote: I think MScomt2 is a version of mscomctl, not really sure. Seems we're all agreed things won't work in 64 bit office. Which is not great for developers. It would take MS days to sort this out, as opposed to developers and clients spending months sorting it out - not to mention us developers who will inevitably end up with soured client relationships due to this. Feels like MS are trying to kill VBA for VSTO. Fine, I'm sure everyone will follow suit, but why screw everyone over in the process? On Friday, 7 September 2012 17:38:42 UTC+1, james D wrote: Hi. I am a VBA developer (Excel mainly) - I have built an Excel dashboard which contains a userform with a treeview on it. It all works fine pre Windows 7 with Office 2010, but with Windows 7 (and Office 2010) the treeview is no longer visible on the form. I have been searching most of the day. I have a registered (as admin) version of mscomctl.ocx in sysWOW64 - still nothing... can anyone help? When I add a reference to mscomctl in Tools/references, then choose additional controls via the toolbox treeview is not in the list... is it supposed to be in mscomctl? Thanks, James NB: This isn't an issue just on my machine, several others have the same issue. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Solution for Index array formula
PFA Cheersss! Rgds//Vabz On Monday, September 10, 2012 10:26:32 AM UTC+5:30, amar takale wrote: Hi All Experts Pls suggestion for required formula On Fri, Sep 7, 2012 at 7:18 PM, amar takale amart...@gmail.comjavascript: wrote: -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Index Array formula.xls Description: MS-Excel spreadsheet
RE: $$Excel-Macros$$ Solution for Index array formula
Hi Amar, For the best response to your questions, please explain your question in your email message. In your follow-up message today, which had neither the question nor the attachment, it was impossible to tell what you needed help with without checking the list archives! Here is a solution. In cell W20 place this formula: =SUMPRODUCT(--($V20=$C$8:$C$17),--($W$14=$D$8:$D$17),--($Y$14=$E$8:$E$17),OF FSET(INDEX($G$7:$I$7,,MATCH(W$19,$G$7:$I$7)),1,($X$14-1)*COLUMNS($F$7:$I$7), ROWS($C$8:$C$17))) Then copy that formula to all other cells in the range W20:Y24 -- the formula will adjust properly for each cell automatically. I notice that You have two groups of names that you are selecting from (with Data Validation in V18). Your existing formulae, and the formula I provided, do not consider the name group as a criterion. For the most part, the names ni each group are different, so in those cases it's irrelevant. But you have a Sam in each group. Both our formulae will return the values for whichever Sam matches all the other criteria -- regardless of name group. Here is an upate to my provided formula that will limit the result to the specified name group, too. Put in cell W20 and copy across and down: =SUMPRODUCT(--($V20=INDIRECT($V$18)),--($W$14=OFFSET(INDIRECT($V$18),,1)),-- ($Y$14=OFFSET(INDIRECT($V$18),,2)),OFFSET(INDEX(OFFSET(OFFSET(INDIRECT($V$18 ),,4)3),,MATCH(W$19,$G$7:$I$7)),,($X$14-1)*COLUMNS($F$7:$I$7),ROWS(OFFSE T(INDIRECT($V$18),,1 Gains in efficiency could be made with further analysis, but hope this helps. If with all your real data the spreadsheet is too slow, you can come back for further help if needed. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Friday, September 07, 2012 6:48 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Solution for Index array formula -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
RE: $$Excel-Macros$$ Re: treeview
Hi James, Microsoft gives warnings about running 64-Bit office, and notifies users in advance that there will be compatibility issues. With 3rd party components, those issues are pretty much unavoidable, but its true Microsoft could have updated their own various components to 64-bit versions for compatibility. These compatibility issues are the same ones that reserved 64-bit web browser versions to experimental use for years. 64-bit Office is not generally recommended yet except for cases of specialized user requirements. What Microsoft should have done, in my view, is allowed side-by-side 32 and 64 bit office installations, and given end-users the best of both worlds on a single workstation. I can understand a reticence to update Visual Basic 5 and 6 components for another architecture, when those components are not part of Office, and the application they are part of -- VB6 -- was released in January 1999 -- approaching 14 years ago. It's great that Microsoft is still maintaining compatibility with those components (not saying they are updating them), including in Windows 8 where they continue to distribute the core components with OS installation. If Common Controls was part of Office, I would say you have a very good argument, but it's part of another application. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of james D Sent: Sunday, September 09, 2012 11:15 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: treeview Sorry, I don't really understand your point. I realise VSTO will be the way to go, I don't really have many issues with that. My point is that I pay MS a lot of money, as do my clients. Solutions have been built in good faith that MS will maintain backwards compatibility, and they are effectively costing myself, and my clients a lot of money - to redevelop solutions, because they don't want to make their new products wholly backwards compatible. I consider that irresponsible and pretty bad in terms of customer service. What argument is there for not making it backwards compatible so existing solutions continue to work? to force all devlopers and clients to buy Visual Studio and redevelop all their existing VBA solutions? Is that not some kind of con? On Sunday, 9 September 2012 14:44:51 UTC+1, bpascal123 wrote: At some point, developing for Office requires access to Visual Studio full package or alternative equivalent tools. I don't think it's about killing VBA for VSTO, I would see this more like setting or defining a border between Office custom solution and Office professional solution. It makes sense, MS wants to keep a hand on major widely used products. To me, as I can't access Visual Studio or other equivalent application for developers, I would look for open source solutions where I can implement a solution that can access system resources and properties... On Saturday, September 8, 2012 10:27:24 AM UTC+1, james D wrote: I think MScomt2 is a version of mscomctl, not really sure. Seems we're all agreed things won't work in 64 bit office. Which is not great for developers. It would take MS days to sort this out, as opposed to developers and clients spending months sorting it out - not to mention us developers who will inevitably end up with soured client relationships due to this. Feels like MS are trying to kill VBA for VSTO. Fine, I'm sure everyone will follow suit, but why screw everyone over in the process? On Friday, 7 September 2012 17:38:42 UTC+1, james D wrote: Hi. I am a VBA developer (Excel mainly) - I have built an Excel dashboard which contains a userform with a treeview on it. It all works fine pre Windows 7 with Office 2010, but with Windows 7 (and Office 2010) the treeview is no longer visible on the form. I have been searching most of the day. I have a registered (as admin) version of mscomctl.ocx in sysWOW64 - still nothing... can anyone help? When I add a reference to mscomctl in Tools/references, then choose additional controls via the toolbox treeview is not in the list... is it supposed to be in mscomctl? Thanks, James NB: This isn't an issue just on my machine, several others have the same issue. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated
RE: $$Excel-Macros$$ Re: treeview
Here's Microsoft's policy spelled out in their words: Visual Basic 6.0 Runtime Usage Inside VBA and Office Visual Basic for Applications, or VBA, is a distinct technology commonly used for application automation and macros inside of other applications, most commonly inside Microsoft Office applications. VBA ships as a part of Office and therefore the support for VBA is governed by the support policy of Office. However, there are situations where VBA is used to call or host Visual Basic 6.0 runtime binaries and controls. In these situations, Visual Basic 6.0 supported runtime files in the OS and the extended file list are also supported when used inside of a supported VBA environment. For VB6 runtime scenarios to be supported inside VBA, all of the following must be true: The host OS version for VB runtime is still supported The host version of Office for VBA is still supported The runtime files in question are still supported That policy and the explanation of support and compatibility for the VS6/VB6 runtimes as a whole can be found at http://msdn.microsoft.com/nb-no/vbrun/ms788708%28en-us%29.aspx. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Monday, September 10, 2012 12:53 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Re: treeview Hi James, Microsoft gives warnings about running 64-Bit office, and notifies users in advance that there will be compatibility issues. With 3rd party components, those issues are pretty much unavoidable, but its true Microsoft could have updated their own various components to 64-bit versions for compatibility. These compatibility issues are the same ones that reserved 64-bit web browser versions to experimental use for years. 64-bit Office is not generally recommended yet except for cases of specialized user requirements. What Microsoft should have done, in my view, is allowed side-by-side 32 and 64 bit office installations, and given end-users the best of both worlds on a single workstation. I can understand a reticence to update Visual Basic 5 and 6 components for another architecture, when those components are not part of Office, and the application they are part of -- VB6 -- was released in January 1999 -- approaching 14 years ago. It's great that Microsoft is still maintaining compatibility with those components (not saying they are updating them), including in Windows 8 where they continue to distribute the core components with OS installation. If Common Controls was part of Office, I would say you have a very good argument, but it's part of another application. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of james D Sent: Sunday, September 09, 2012 11:15 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: treeview Sorry, I don't really understand your point. I realise VSTO will be the way to go, I don't really have many issues with that. My point is that I pay MS a lot of money, as do my clients. Solutions have been built in good faith that MS will maintain backwards compatibility, and they are effectively costing myself, and my clients a lot of money - to redevelop solutions, because they don't want to make their new products wholly backwards compatible. I consider that irresponsible and pretty bad in terms of customer service. What argument is there for not making it backwards compatible so existing solutions continue to work? to force all devlopers and clients to buy Visual Studio and redevelop all their existing VBA solutions? Is that not some kind of con? On Sunday, 9 September 2012 14:44:51 UTC+1, bpascal123 wrote: At some point, developing for Office requires access to Visual Studio full package or alternative equivalent tools. I don't think it's about killing VBA for VSTO, I would see this more like setting or defining a border between Office custom solution and Office professional solution. It makes sense, MS wants to keep a hand on major widely used products. To me, as I can't access Visual Studio or other equivalent application for developers, I would look for open source solutions where I can implement a solution that can access system resources and properties... On Saturday, September 8, 2012 10:27:24 AM UTC+1, james D wrote: I think MScomt2 is a version of mscomctl, not really sure. Seems we're all agreed things won't work in 64 bit office. Which is not great for developers. It would take MS days to sort this out, as opposed to developers and clients spending months sorting it out - not to mention us developers who will inevitably end up with soured client relationships due to this. Feels like MS are trying to kill VBA for VSTO. Fine, I'm sure everyone will follow suit, but why screw everyone over in the process? On Friday, 7 September 2012 17:38:42 UTC+1, james D wrote: Hi. I am a VBA developer (Excel mainly) - I have built an Excel dashboard which
$$Excel-Macros$$ RE: SAP FICO group
Hi All, First of all thanks to all experts who helping to the world with their expertise knowledge and giving such a big opportunity to learn Excel and VBA so closely. I also wanted to learn similar kind of logics and participate in discussion for gaining knowledge of SAP FI CO Module, if you aware about such kind of groups can you please share their email ID. Regards,Anil Bhange IP Phone - 800105 | Mobile - +31 6 1192 3971 -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
FW: $$Excel-Macros$$ Required Revenue started from Date..
Hi Don, Thanks for your post, I was trying to understand the formula, if we use array formula then below highlighted cells also getting fixed and formula is not giving the proper result, =INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV20,0)) Can you please share the formula in excel file, to understand better. Regards,Anil Bhange IP Phone - 800105 | Mobile - +31 6 1192 3971 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Friday, August 31, 2012 03:10 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Revenue started from Date.. This is an array formula that must be entered using ctrl+shift+enter =INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV20,0)) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.commailto:dguille...@gmail.com From: Kuldeep Singhmailto:naukrikuld...@gmail.com Sent: Friday, August 31, 2012 7:35 AM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Required Revenue started from Date.. Hi Experts, I want to required Revenue started from Date. Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.commailto:naukrikuld...@gmail.com || www.naukri.comhttp://www.naukri.com Please Consider the environment. Please don't print this e-mail unless you really need to. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. To unsubscribe from this group, send email to
$$Excel-Macros$$ Re: Formula to Calculate Slab Wise Commission as per Targets Achieved
Hello, Thanks for the solution. But I would prefer it to have in respective applicable columns please. Regards Rashid On Monday, September 10, 2012 8:57:27 AM UTC+4, Vabz wrote: Hi Do you want comm. to be shown in respective applicable col. only or pl check soln i have given. Rgds//Vabz On Monday, September 10, 2012 1:20:05 AM UTC+5:30, prkhan56 wrote: Hello All, We have a group of employees having various Grades and Position. 1) A fixed target of sales to be achieved every month as shown in Col D (Target). 2) Each level has different Target Criteria as shown in Col C5. 3) Commission Criteria is shown in F3:K3 4) Achievement Criteria is shown in F2:K2 5) Target achieved by each is shown in Col E5 downwards. Can anyone please provide a formula which will calculate the commission according to the Target achieved against each employee? If they achieve 75-79% they get 50% of target achieved, 80-85% then 60% and so on so forth. I require the formula in F5:K5 (red color cells) to drag it down and across to get the desired figures. Thanks Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Copy paste of data from 1 sheet to all sheet at a time
If I want to copy paste say data from cell X1 to AA10 from 1 sheet to all the sheets in the same file, is there any shortcut available? Best Regards, Amit 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Re: Formula to Calculate Slab Wise Commission as per Targets Achieved
Ok Dear.. PFA Cheerz.. Rgds\\Vabz On Monday, September 10, 2012 1:58:09 PM UTC+5:30, prkhan56 wrote: Hello, Thanks for the solution. But I would prefer it to have in respective applicable columns please. Regards Rashid On Monday, September 10, 2012 8:57:27 AM UTC+4, Vabz wrote: Hi Do you want comm. to be shown in respective applicable col. only or pl check soln i have given. Rgds//Vabz On Monday, September 10, 2012 1:20:05 AM UTC+5:30, prkhan56 wrote: Hello All, We have a group of employees having various Grades and Position. 1) A fixed target of sales to be achieved every month as shown in Col D (Target). 2) Each level has different Target Criteria as shown in Col C5. 3) Commission Criteria is shown in F3:K3 4) Achievement Criteria is shown in F2:K2 5) Target achieved by each is shown in Col E5 downwards. Can anyone please provide a formula which will calculate the commission according to the Target achieved against each employee? If they achieve 75-79% they get 50% of target achieved, 80-85% then 60% and so on so forth. I require the formula in F5:K5 (red color cells) to drag it down and across to get the desired figures. Thanks Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Commission-Excel Group.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Copy paste of data from 1 sheet to all sheet at a time
Dear Noorain, Can we also sort all sheet together as I have common column? Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 10 September 2012 14:34 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Copy paste of data from 1 sheet to all sheet at a time Dear Amit, First you copy required data from X1 ti AA10 then group the all sheets using ctrl+pgDn then paste, it will applicable for all sheets of Activeworkbook. On Mon, Sep 10, 2012 at 2:24 PM, Amit Desai (MERU) amit.de...@merucabs.commailto:amit.de...@merucabs.com wrote: If I want to copy paste say data from cell X1 to AA10 from 1 sheet to all the sheets in the same file, is there any shortcut available? Best Regards, Amit 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros%2bunsubscr...@googlegroups.com. -- With Regards, Noorain Ansari http://http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http://http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros+unsubscr...@googlegroups.com. 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
Re: $$Excel-Macros$$ Solution for Index array formula
Dear Asa Can u explain logic step by step. Rgds//Vabz On Monday, September 10, 2012 12:43:21 PM UTC+5:30, Asa R. wrote: Hi Amar, For the best response to your questions, please explain your question in your email message. In your follow-up message today, which had neither the question nor the attachment, it was impossible to tell what you needed help with without checking the list archives! *Here is a solution.* *In cell **W20 **place this formula:* =SUMPRODUCT(--($V20=$C$8:$C$17),--($W$14=$D$8:$D$17),--($Y$14=$E$8:$E$17),OFFSET(INDEX($G$7:$I$7,,MATCH(W$19,$G$7:$I$7)),1,($X$14-1)*COLUMNS($F$7:$I$7),ROWS($C$8:$C$17))) *Then copy that formula to all other cells in the range **W20:Y24* -- the formula will adjust properly for each cell automatically. I notice that You have two groups of names that you are selecting from (with Data Validation in V18). Your existing formulae, and the formula I provided, do not consider the name group as a criterion. For the most part, the names ni each group are different, so in those cases it's irrelevant. But you have a Sam in each group. Both our formulae will return the values for whichever Sam matches all the other criteria -- regardless of name group. Here is an upate to my provided *formula that will limit the result to the specified name group*, too. *Put in cell **W20* and copy across and down: =SUMPRODUCT(--($V20=INDIRECT($V$18)),--($W$14=OFFSET(INDIRECT($V$18),,1)),--($Y$14=OFFSET(INDIRECT($V$18),,2)),OFFSET(INDEX(OFFSET(OFFSET(INDIRECT($V$18),,4)3),,MATCH(W$19,$G$7:$I$7)),,($X$14-1)*COLUMNS($F$7:$I$7),ROWS(OFFSET(INDIRECT($V$18),,1 Gains in efficiency could be made with further analysis, but hope this helps. If with all your real data the spreadsheet is too slow, you can come back for further help if needed. Asa *From:* excel-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *amar takale *Sent:* Friday, September 07, 2012 6:48 AM *To:* excel-...@googlegroups.com javascript: *Subject:* $$Excel-Macros$$ Solution for Index array formula -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES.
Dear members The following macro I am using to match the values of col A and Col C with Col E and Col G and if matched update the value of Col B to Col. F and the value of Col D to Col H. Its working fine on small data but on large data its taking time can anyone suggest some correction or improvement in this macro. Due to the size limit of the group I did not attached the file. Siraj Option Explicit Sub checksyssystem1() Dim r As Long Dim r1 As Long Dim c As Long For r = 2 To Cells(Rows.Count, a).End(xlUp).Row For r1 = 2 To Cells(Rows.Count, g).End(xlUp).Row If Cells(r, a) = Cells(r1, e) And Cells(r, c) = Cells(r1, g) Then Cells(r1, f) = Cells(r, b) Cells(r1, h) = Cells(r, d) If Cells(r, a) = Then Exit For End If End If Next r1 Next r End Sub -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Dear Mangesh, you can use text to colum Regard Manoj On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your response. Thanks. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. image.png
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Yes u r right. I did by using Text to Column option. Its works fine. But I need it by using formula. Thanks On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Mangesh, you can use text to colum Regard Manoj On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your response. Thanks. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. image.png
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Hi Mangesh.. PFA.. Cheers Rgds//Vabz On Monday, September 10, 2012 4:41:13 PM UTC+5:30, Mangesh wrote: Yes u r right. I did by using Text to Column option. Its works fine. But I need it by using formula. Thanks On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar kumarman...@gmail.comjavascript: wrote: Dear Mangesh, you can use text to colum Regard Manoj On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay manges...@gmail.comjavascript: wrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your response. Thanks. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-...@googlegroups.comjavascript: . To unsubscribe from this group, send email to excel-macros...@googlegroups.com javascript:. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Need help - To divide the string into three parts.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Rank Formula.........
Wow!!! Thanks. On Mon, Sep 10, 2012 at 1:09 AM, David Grugeon da...@grugeon.com.au wrote: See attached On 10 September 2012 05:02, Dhananjay Pinjan dppin...@gmail.com wrote: Dear Experts, I need a solution as per my query in attached file. Pl. revert in case of any clarification or any confusion. Regards, Dhananjay -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Regards David Grugeon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES.
Option Explicit Sub checksyssystem1() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Dim r As Long Dim r1 As Long Dim c As Long For r = 2 To Cells(Rows.Count, a).End(xlUp).Row For r1 = 2 To Cells(Rows.Count, g).End(xlUp).Row If Cells(r, a) = Cells(r1, e) And Cells(r, c) = Cells(r1, g) Then Cells(r1, f) = Cells(r, b) Cells(r1, h) = Cells(r, d) If Cells(r, a) = Then Exit For End If End If Next r1 Next r Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True End Sub On 10 September 2012 21:04, Siraj Momin (BTG) smo...@ccc.ae wrote: Dear members The following macro I am using to match the values of col A and Col C with Col E and Col G and if matched update the value of Col B to Col. F and the value of Col D to Col H. Its working fine on small data but on large data its taking time can anyone suggest some correction or improvement in this macro. Due to the size limit of the group I did not attached the file. Siraj Option Explicit Sub checksyssystem1() Dim r As Long Dim r1 As Long Dim c As Long For r = 2 To Cells(Rows.Count, a).End(xlUp).Row For r1 = 2 To Cells(Rows.Count, g).End(xlUp).Row If Cells(r, a) = Cells(r1, e) And Cells(r, c) = Cells(r1, g) Then Cells(r1, f) = Cells(r, b) Cells(r1, h) = Cells(r, d) If Cells(r, a) = Then Exit For End If End If Next r1 Next r End Sub -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Regards David Grugeon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Re: Need help - To divide the string into three parts
Hi Mangesh, Try this hope tghis will help you. =TRIM(MID(SUBSTITUTE($A$1,,,REPT( ,LEN($A$1))),((COLUMNS($A$1:A1)-1)*LEN($A$1))+1,LEN($A$1))) paste this in B2 then press f2 select B2 to D2 and CSE regards Prince On Monday, September 10, 2012 4:34:33 PM UTC+5:30, Mangesh wrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your response. Thanks. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
In B2 put =LEFT(A2,FIND(,,A2)-1) In C2 put =MID(A2,LEN(B2)+2,FIND(,,A2,LEN(B2)+2)-LEN(B2)-2) In d2 put =MID(A2,LEN(B2C2)+3,99) On 10 September 2012 21:04, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your response. Thanks. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Regards David Grugeon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. image.png
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Thanks ALL for the Great Help !!! On Mon, Sep 10, 2012 at 5:25 PM, David Grugeon da...@grugeon.com.au wrote: In B2 put =LEFT(A2,FIND(,,A2)-1) In C2 put =MID(A2,LEN(B2)+2,FIND(,,A2,LEN(B2)+2)-LEN(B2)-2) In d2 put =MID(A2,LEN(B2C2)+3,99) On 10 September 2012 21:04, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your response. Thanks. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Regards David Grugeon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. image.png
Re: $$Excel-Macros$$ Required Revenue started from Date..
Send ME your file Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Anil Bhange Sent: Monday, September 10, 2012 3:10 AM To: excel-macros@googlegroups.com Subject: FW: $$Excel-Macros$$ Required Revenue started from Date.. Hi Don, Thanks for your post, I was trying to understand the formula, if we use array formula then below highlighted cells also getting fixed and formula is not giving the proper result, =INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV20,0)) Can you please share the formula in excel file, to understand better. Regards,Anil Bhange IP Phone – 800105 | Mobile - +31 6 1192 3971 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Friday, August 31, 2012 03:10 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required Revenue started from Date.. This is an array formula that must be entered using ctrl+shift+enter =INDEX($D$1:$IV$1,MATCH(TRUE,D2:IV20,0)) Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kuldeep Singh Sent: Friday, August 31, 2012 7:35 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Required Revenue started from Date.. Hi Experts, I want to required Revenue started from Date. Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com Please Consider the environment. Please don't print this e-mail unless you really need to. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Why clutter it up by using UN necessary formulas to clutter up the file? Unless, of course, this is HOMEWORK Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mangesh Vimay Sent: Monday, September 10, 2012 6:11 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts Yes u r right. I did by using Text to Column option. Its works fine. But I need it by using formula. Thanks On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar kumarmanoj.11...@gmail.com wrote: Dear Mangesh, you can use text to colum Regard Manoj On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : Waiting for your response. Thanks. -- With regards, MaNgEsH -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to mailto:excel-macros%2bunsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to mailto:excel-macros%2bunsubscr...@googlegroups.com. -- With regards, MaNgEsH -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
$$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES.
Dear members The following macro I am using to match the values of col A and Col C with Col E and Col G and if matched update the value of Col B to Col. F and the value of Col D to Col H. Its working fine on small data but on large data its taking time can anyone suggest some correction or improvement in this macro. Due to the size limit of the group I did not attached the file. Siraj Option Explicit Sub checksyssystem1() Dim r As Long Dim r1 As Long Dim c As Long For r = 2 To Cells(Rows.Count, a).End(xlUp).Row For r1 = 2 To Cells(Rows.Count, g).End(xlUp).Row If Cells(r, a) = Cells(r1, e) And Cells(r, c) = Cells(r1, g) Then Cells(r1, f) = Cells(r, b) Cells(r1, h) = Cells(r, d) If Cells(r, a) = Then Exit For End If End If Next r1 Next r End Sub -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
RE: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved
See the attached Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rashid Khan Sent: 10 September 2012 1:20 To: excel-macros Subject: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved Hello All, We have a group of employees having various Grades and Position. 1) A fixed target of sales to be achieved every month as shown in Col D (Target). 2) Each level has different Target Criteria as shown in Col C5. 3) Commission Criteria is shown in F3:K3 4) Achievement Criteria is shown in F2:K2 5) Target achieved by each is shown in Col E5 downwards. Can anyone please provide a formula which will calculate the commission according to the Target achieved against each employee? If they achieve 75-79% they get 50% of target achieved, 80-85% then 60% and so on so forth. I require the formula in F5:K5 (red color cells) to drag it down and across to get the desired figures. Thanks Rashid Khan -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Copy of Commission-Excel Group.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ MMULT functions questions
No Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of attapan_chainarongb...@ck-mail.com Sent: 10 September 2012 8:51 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ MMULT functions questions Dear Rajan Thanks for your idea, If I've have many row (data) ,So it still work ? Attapan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Sunday, September 09, 2012 1:18 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ MMULT functions questions =MMULT(OFFSET(INDEX($A$3:$A$5,MATCH(A23,$A$3:$A$5,0),1),,1,1,4),TRANSPOSE(CH OOSE({1,3,2,4},TRANSPOSE($B$9:$F$9),TRANSPOSE($B$10:$F$10),TRANSPOSE($B$11:$ F$11),TRANSPOSE($B$12:$F$12 With CSE Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of attapan_chainarongb...@ck-mail.com Sent: 08 September 2012 6:49 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ MMULT functions questions One more question 1. If in table one Product No. not sory by (A,B,C) but it alternate (Example C,A,B or A,C,B) (See green hightlight) 2. How can I get it on table 4 ? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Friday, September 07, 2012 9:30 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ MMULT functions questions Use this as array =MMULT(OFFSET(INDEX($A$3:$A$5,MATCH(A23,$A$3:$A$5,0),1),,1,1,4),$B$9:$F$12) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of attapan_chainarongb...@ck-mail.com Sent: 07 September 2012 5:07 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ MMULT functions questions Dear All expert Please help me to find the answer. 1. Table1(BOM) and Table2(Forecast) 2. I used MMULT to get matrix value( array1 * array2) = table3 3. Please see table4 (If Part not sort by (A,B,C) but It alternate by (C,A,B) 4. How can I get this answers(table4) Please advise me Rdgs -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Hi Guillett, I would like to know all possible ways of cutting the string into three parts. So please do needful by suggesting very simple formula for same. Thanks !!! On Mon, Sep 10, 2012 at 5:40 PM, dguillett1 dguille...@gmail.com wrote: Why clutter it up by using UN necessary formulas to clutter up the file? Unless, of course, this is HOMEWORK Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Mangesh Vimay mangesh.da...@gmail.com *Sent:* Monday, September 10, 2012 6:11 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need help - To divide the string into three parts Yes u r right. I did by using Text to Column option. Its works fine. But I need it by using formula. Thanks On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Mangesh, you can use text to colum Regard Manoj On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your response. Thanks. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to mailto:excel-macros%2bunsubscr...@googlegroups.comexcel-macros%2bunsubscr...@googlegroups.com . -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to mailto:excel-macros%2bunsubscr...@googlegroups.comexcel-macros%2bunsubscr...@googlegroups.com . -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use
$$Excel-Macros$$ Re: Formula to Calculate Slab Wise Commission as per Targets Achieved
On Sunday, September 9, 2012 11:50:05 PM UTC+4, prkhan56 wrote: Hello All, We have a group of employees having various Grades and Position. 1) A fixed target of sales to be achieved every month as shown in Col D (Target). 2) Each level has different Target Criteria as shown in Col C5. 3) Commission Criteria is shown in F3:K3 4) Achievement Criteria is shown in F2:K2 5) Target achieved by each is shown in Col E5 downwards. Can anyone please provide a formula which will calculate the commission according to the Target achieved against each employee? If they achieve 75-79% they get 50% of target achieved, 80-85% then 60% and so on so forth. I require the formula in F5:K5 (red color cells) to drag it down and across to get the desired figures. Thanks Rashid Khan Thanks Rajan and Vabz...works great -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
As I said, I would simply use TTC Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mangesh Vimay Sent: Monday, September 10, 2012 9:24 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts Hi Guillett, I would like to know all possible ways of cutting the string into three parts. So please do needful by suggesting very simple formula for same. Thanks !!! On Mon, Sep 10, 2012 at 5:40 PM, dguillett1 dguille...@gmail.com wrote: Why clutter it up by using UN necessary formulas to clutter up the file? Unless, of course, this is HOMEWORK Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Mangesh Vimay Sent: Monday, September 10, 2012 6:11 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help - To divide the string into three parts Yes u r right. I did by using Text to Column option. Its works fine. But I need it by using formula. Thanks On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar kumarmanoj.11...@gmail.com wrote: Dear Mangesh, you can use text to colum Regard Manoj On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : Waiting for your response. Thanks. -- With regards, MaNgEsH -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to mailto:excel-macros%2bunsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to mailto:excel-macros%2bunsubscr...@googlegroups.com. -- With regards, MaNgEsH -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal
RE: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES.
Can you attached sample data file? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Siraj Momin (BTG) Sent: 10 September 2012 7:11 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES. Dear members The following macro I am using to match the values of col A and Col C with Col E and Col G and if matched update the value of Col B to Col. F and the value of Col D to Col H. Its working fine on small data but on large data its taking time can anyone suggest some correction or improvement in this macro. Due to the size limit of the group I did not attached the file. Siraj Option Explicit Sub checksyssystem1() Dim r As Long Dim r1 As Long Dim c As Long For r = 2 To Cells(Rows.Count, a).End(xlUp).Row For r1 = 2 To Cells(Rows.Count, g).End(xlUp).Row If Cells(r, a) = Cells(r1, e) And Cells(r, c) = Cells(r1, g) Then Cells(r1, f) = Cells(r, b) Cells(r1, h) = Cells(r, d) If Cells(r, a) = Then Exit For End If End If Next r1 Next r End Sub -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES.
First of all, Your statement of work and you program is backwards. You SAID: ... if matched update the value of Col B to Col. F and the value of Col D to Col H but your program says: Cells(r1, f) = Cells(r, b) Cells(r1, h) = Cells(r, d) which is setting F to B, not B to F... just so we're clear as to which one you intend... Next: This WOULD work ok with a small data set. but: let's say you have 1000 rows. for each of the 1000 rows, you're making 1000 COMPARISONS. That's 1,000,000 comparisons.. for ONLY 1000 rows. If your data set was 10,000 rows, that would be 100,000,000 comparisions. That WOULD take a while. in your comparisons though, once you find a match, you should stop looking. add a Exit For to: Cells(r1, f) = Cells(r, b) Cells(r1, h) = Cells(r, d) Exit for Unless you EXPECT an additional match and you want to keep the later one. In which case, I would reverse the loop and search from the bottom up: For r1 = Cells(Rows.Count, g).End(xlUp).Row to 2 step -1 === Now, if you REALLY want cut out some time, I would: Load a Data Dictionary object Then check for the values in the Dictionary and update the values stored there. === I tested your previous macro on 10,000 rows. It took 25 minutes. I tested the following macro on 100,000 rows. It took 16 seconds I know which one *I* would prefer! == Sub CheckSystem2() Dim Dict_Data Dim r As Long Dim c As Long Dim nRows, dArray Dim tstart, tstop, tElapsed, tMin, tSec tstart = Timer Set Dict_Data = CreateObject(Scripting.Dictionary) nRows = Cells(Rows.Count, a).End(xlUp).Row For r = 2 To nRows If (r Mod 100 = 0) Then Application.StatusBar = Loading Dictionary: r of Cells(Rows.Count, a).End(xlUp).Row If (Not Dict_Data.exists(Cells(r, e).Value | Cells(r, g).Value)) Then Dict_Data.Add Cells(r, e).Value | Cells(r, g).Value, Cells(r, b).Value | Cells(r, d).Value End If Next r For r = 2 To nRows If (r Mod 100 = 0) Then Application.StatusBar = r of Cells(Rows.Count, a).End(xlUp).Row End If If (Dict_Data.exists(Cells(r, a).Value | Cells(r, c).Value)) Then dArray = Split(Dict_Data.Item(Cells(r, a).Value | Cells(r, c).Value), |) Cells(r, f) = dArray(0) Cells(r, h) = dArray(1) End If Next r Application.StatusBar = False tstop = Timer tElapsed = tstop - tstart tMin = tElapsed \ 60 tSec = tElapsed Mod 60 MsgBox Finished Chr(13) tMin min tSec sec End Sub Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Siraj Momin (BTG) smo...@ccc.ae To: excel-macros@googlegroups.com Sent: Mon, September 10, 2012 9:41:53 AM Subject: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH COLUMN E AND G AND UPDATE THE VALUES. Dear members The following macro I am using to match the values of col A and Col C with Col E and Col G and if matched update the value of Col B to Col. F and the value of Col D to Col H. Its working fine on small data but on large data its taking time can anyone suggest some correction or improvement in this macro. Due to the size limit of the group I did not attached the file. Siraj Option Explicit Sub checksyssystem1() Dim r As Long Dim r1 As Long Dim c As Long For r = 2 To Cells(Rows.Count, a).End(xlUp).Row For r1 = 2 To Cells(Rows.Count, g).End(xlUp).Row If Cells(r, a) = Cells(r1, e) And Cells(r, c) = Cells(r1, g) Then Cells(r1, f) = Cells(r, b) Cells(r1, h) = Cells(r, d) If Cells(r, a) = Then Exit For End If End If Next r1 Next r End Sub-- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook.
Re: $$Excel-Macros$$ countdown macro needed.........
Did you not like the solution I provided? Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Anil Bhange anil.bha...@tatacommunications.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Fri, September 7, 2012 4:41:31 PM Subject: FW: $$Excel-Macros$$ countdown macro needed. Hi Experts, I am also looking for this solution, can you please help. Regards, Anil Bhange IP Phone - 800105 | Mobile - +31 6 1192 3971 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dhananjay Pinjan Sent: Wednesday, August 29, 2012 07:39 PM To: excel-macros Subject: $$Excel-Macros$$ countdown macro needed. Hi Experts, I need a countdown macro as per attched file. Pl. help. Regards, Dhananjay -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Urgent... Please Help... (place useless subject here)
WHEW! I was incommunicado for the last 3 days... Just spent the last 40 minutes sorting through 246 unread emails. Started by sorting by Subject and deleting anything with: Re: $$Excel-Macros$$ Re: Re: $$Excel-Macros$$ URGENT Re: $$Excel-Macros$$ Please Help THAT took care of 100+ ... I MIGHT have been able to help. I MIGHT have already had all the code written that they would ever need... Now we'll never know... :o) Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: David Grugeon da...@grugeon.com.au To: excel-macros@googlegroups.com Sent: Fri, September 7, 2012 5:01:10 PM Subject: Re: $$Excel-Macros$$ Urgent... Please Help... (place useless subject here) Why cant these guys see that I don't want to take the time (and risk) of downloading a file unless I know I can contribute and/or I find the problem interesting. Another issue I have is that some users change the subject when replying. this breaks up conversations, So please do not add anything to the subject line when replying. Just hit reply and put what you want in the body of the text. On 8 September 2012 05:25, Mangesh Vimay mangesh.da...@gmail.com wrote: Thats Great !!! On 9/8/12, dguillett1 dguille...@gmail.com wrote: me too.. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Friday, September 07, 2012 11:16 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent... Please Help... (place useless subject here) Is it me? or does the use of this type of Subject line seem to be increasing lately? I think we (those that enjoy lending assistance) ought to each start a log file. In it, place the name of each person that says Urgent, and Please Help or some other useless subject. Then, they'll received ONE reminder. After that, if they do it again, we'll either ignore them or send some kind of equally useless response. Like: 66,000... all orange... hope this helps (lol) I wonder if the site design would allow the Forum Rules to display at the TOP of the window when creating a New Topic I suspect that many people have found the Group through Google and have never bothered to read the rules. Although, IMHO they shouldn't NEED to read them, since they are really common sense. I mean really: If you want someone to help you, tell them what you need. (And please.. don't get upset if they cannot read your mind.) Is that so difficult? Paul S. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this
RE: $$Excel-Macros$$ countdown macro needed.........
See the attached Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anil Bhange Sent: 08 September 2012 2:03 To: excel-macros@googlegroups.com Subject: FW: $$Excel-Macros$$ countdown macro needed. Hi Experts, I am also looking for this solution, can you please help. Regards, Anil Bhange IP Phone - 800105 | Mobile - +31 6 1192 3971 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dhananjay Pinjan Sent: Wednesday, August 29, 2012 07:39 PM To: excel-macros Subject: $$Excel-Macros$$ countdown macro needed. Hi Experts, I need a countdown macro as per attched file. Pl. help. Regards, Dhananjay -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Copy of Need Countdown Macro.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Thanks all for their great support to solve this problem. On Mon, Sep 10, 2012 at 8:27 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Would it be simple for you* * * *Function SplitString(rngRange As Range) As Variant* *SplitString = Split(rngRange.Value, ,)* *End Function* * * *See the attached file.* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay *Sent:* 10 September 2012 7:55 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need help - To divide the string into three parts ** ** Hi Guillett, ** ** I would like to know all possible ways of cutting the string into three parts. So please do needful by suggesting very simple formula for same.*** * Thanks !!! On Mon, Sep 10, 2012 at 5:40 PM, dguillett1 dguille...@gmail.com wrote:* *** Why clutter it up by using UN necessary formulas to clutter up the file? Unless, of course, this is HOMEWORK Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Mangesh Vimay mangesh.da...@gmail.com *Sent:* Monday, September 10, 2012 6:11 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need help - To divide the string into three parts Yes u r right. I did by using Text to Column option. Its works fine. But I need it by using formula. Thanks ** ** On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar kumarmanoj.11...@gmail.com wrote: Dear Mangesh, you can use text to colum Regard Manoj ** ** On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your response. Thanks. -- With regards, ** ** *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to mailto:excel-macros%2bunsubscr...@googlegroups.comexcel-macros%2bunsubscr...@googlegroups.com . -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to mailto:excel-macros%2bunsubscr...@googlegroups.comexcel-macros%2bunsubscr...@googlegroups.com . -- With regards, ** ** *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
Re: $$Excel-Macros$$ Re: automatic update totals in cumulative colums
impressive Vaibhav .this will reduced my task, time drastically . just one more why we cant the results for the % column feature from Pivot for the same. From: Vabz in.vaib...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, 10 September 2012 5:25 PM Subject: $$Excel-Macros$$ Re: automatic update totals in cumulative colums PFA I have given two Solutions one is based on Pivot Table One is based on formula that you have to tabilate.. Cheerz.. Rgds//Vabz On Thursday, September 6, 2012 2:58:40 PM UTC+5:30, excel lerner wrote: Hello sir In my attached files file1.xls is one month reports. file2.xls is next month reports. I want to cumulative values in cumulative columns automatically when i enterd present month values in monthly columns. Please help me. Thanks in advance -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Re: automatic update totals in cumulative colums
At present there is no such predefined function to give cumulative value as desired by you. I'll try to tweak n find solution. Good Night ... Cheerz n Thanks Rgds//Vabz -Original Message- From: shashank bhosle catchshashankbho...@yahoo.co.in Sender: excel-macros@googlegroups.com Date: Tue, 11 Sep 2012 01:56:56 To: excel-macros@googlegroups.comexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: automatic update totals in cumulative colums impressive Vaibhav .this will reduced my task, time drastically . just one more why we cant the results for the % column feature from Pivot for the same. From: Vabz in.vaib...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, 10 September 2012 5:25 PM Subject: $$Excel-Macros$$ Re: automatic update totals in cumulative colums PFA I have given two Solutions one is based on Pivot Table One is based on formula that you have to tabilate.. Cheerz.. Rgds//Vabz On Thursday, September 6, 2012 2:58:40 PM UTC+5:30, excel lerner wrote: Hello sir In my attached files file1.xls is one month reports. file2.xls is next month reports. I want to cumulative values in cumulative columns automatically when i enterd present month values in monthly columns. Please help me. Thanks in advance -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ detecting loggedin user
Hi, You can try this. =INDEX('YTD Output'!$F$2:$F$228,MATCH('YTD Performance'!C8,'YTD Output'!$C$2:$C$228,0)) =INDEX('YTD Output'!$H$2:$H$228,MATCH('YTD Performance'!C9,'YTD Output'!$F$2:$F$228,0)) Regards, Kuldeep Singh On Mon, Sep 10, 2012 at 10:34 PM, Midhun Thampan midhun.tham...@gmail.comwrote: Hi All; This is a excel file which has a database which will be locked. Just need a code tht will detect only the information of user who logs on the computer. Our system is logged in via 5 digit userid so as someone opens this file his userid should detected so tht he can only view his particular performance.. Kindly help, i tried but did not work. -- Midhun -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ detecting loggedin user
Here's something I threw together from macros I already had. I didn't spend too much time on it. I hope they have what you're looking for. There are several things you MENTIONED that I tried to include. Since you want the user to view ONLY his performance, I added filters to the YTD Output sheet and protected it with a password testpassword. (you can change it to whatever you wish) The file should be saved with only blank rows displayed and password protected. You'll also want to password protect your VBA project so that the users won't be able to open the VBEditor and read the sheet password. When the user opens the file, it determines the user's ID based on his/her Windows login. It then updates the Userid in the YTD Performance sheet. A change Event on this sheet checks for a changed userid and calls a function that unprotects the Output sheet, changes the filter to include only the userid, then re-protects the sheet. hope this gives you enough to work with to complete your task. Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Midhun Thampan midhun.tham...@gmail.com To: excel-macros@googlegroups.com Sent: Mon, September 10, 2012 1:04:27 PM Subject: $$Excel-Macros$$ detecting loggedin user Hi All; This is a excel file which has a database which will be locked. Just need a code tht will detect only the information of user who logs on the computer. Our system is logged in via 5 digit userid so as someone opens this file his userid should detected so tht he can only view his particular performance.. Kindly help, i tried but did not work. -- Midhun -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. OUTPUT.xlsb Description: application/vnd.ms-excel.sheet.binary.macroenabled.12
Re: $$Excel-Macros$$ entering Array formula in lookup function
I'm sorry gentlemen. I was out of the office for a few days. (Actually, I'm not sorry... I needed the time off!) As Sam (I believed) surmised, the actual problem was that I couldn't get the CSE to work properly. It kept wanting to create the array function as: ={LOOKUP(A2,0,1,2,3,4,5,6,7,8,9,#,#,#,#,#,#,#,#,#)} instead of =LOOKUP(A2,{0,1,2,3,4,5,6,7,8,9},{#,#,#,#,#,#,#,#,#}) I couldn't figure out how to get it to work as a function. I managed to do it quite easily with VBA, and I simply wrote a UDF for the user to accomplish his task. To REALLY get on my good side, he didn't NEED it. He was just wondering if it could be done! He's now VERY low on my priority assistance list! Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Sam Mathai Chacko samde...@gmail.com To: excel-macros@googlegroups.com Sent: Sat, September 8, 2012 7:11:19 AM Subject: Re: $$Excel-Macros$$ entering Array formula in lookup function Well, I guess then it's up to Paul to clarify what he's finding hard to do here. Sam On Sat, Sep 8, 2012 at 2:34 PM, David Grugeon da...@grugeon.com.au wrote: This is an array option in the formula and does not have to be entered with CSE. It is just overloaded. You put the curly brackets in manually. David On 8 September 2012 17:44, Sam Mathai Chacko samde...@gmail.com wrote: Dave, I guess Paul's issue is more on not being able to enter this as an array formula. Changing the vector array elements to strings probably doesn't really make a difference if the issue is about entering the CSE formula. Regards, Sam Mathai Chacko On Sat, Sep 8, 2012 at 1:38 AM, David Grugeon da...@grugeon.com.au wrote: The numbers are strings too =LOOKUP(A2,{0,1,2,3,4,5,6,7,8,9},{#,#,#,#,#,#,#,#,#}) ) Regards David Grugeon On 8 September 2012 03:57, Paul Schreiner schreiner_p...@att.net wrote: Sorry, I copy/pasted the wrong one. I'm still having trouble inserting it as an array function. thanks, Paul - “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: Sam Mathai Chacko samde...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, September 7, 2012 1:26:28 PM Subject: Re: $$Excel-Macros$$ entering Array formula in lookup function Shouldn't they be strings? =LOOKUP(A2,{0,1,2,3,4,5,6,7,8,9},{#,#,#,#,#,#,#,#,#}) Regards, Sam Mathai Chacko On Fri, Sep 7, 2012 at 10:37 PM, Paul Schreiner schreiner_p...@att.net wrote: Odd... I seem to be suffering a temporary loss of cognitive function. (can't think straight) I'm trying to use Lookup() to replace numbers with # I THOUGHT I could enter it as an array function like: =Lookup(A2,{0,1,2,3,4,5,6,7,8,9},{#,#,#,#,#,#,#,#,#,#}) but I cannot seem to figure out how to get it to enter as an array function. I'm actually trying to DISPLAY a cell that has a PIN and blank out all except the last (4) digits So: A2 is 123-45-6789 the result of the lookup would be: B2: ###-##-6789 However, the original string isn't always formatted the same. I need to retain the non-numeric characters. Any ideas? Maybe I just need an Array Formula refresher Hmm... Paul S. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- Join official
RE: $$Excel-Macros$$ MMULT functions questions
Ok, Thanks you for make me clear about this Your help is appreciate From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Monday, September 10, 2012 8:55 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ MMULT functions questions No Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]mailto:[mailto:excel-macros@googlegroups.com] On Behalf Of attapan_chainarongb...@ck-mail.commailto:attapan_chainarongb...@ck-mail.com Sent: 10 September 2012 8:51 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ MMULT functions questions Dear Rajan Thanks for your idea, If I've have many row (data) ,So it still work ? Attapan. From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]mailto:[mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Sunday, September 09, 2012 1:18 PM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ MMULT functions questions =MMULT(OFFSET(INDEX($A$3:$A$5,MATCH(A23,$A$3:$A$5,0),1),,1,1,4),TRANSPOSE(CHOOSE({1,3,2,4},TRANSPOSE($B$9:$F$9),TRANSPOSE($B$10:$F$10),TRANSPOSE($B$11:$F$11),TRANSPOSE($B$12:$F$12 With CSE Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]mailto:[mailto:excel-macros@googlegroups.com] On Behalf Of attapan_chainarongb...@ck-mail.commailto:attapan_chainarongb...@ck-mail.com Sent: 08 September 2012 6:49 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ MMULT functions questions One more question 1. If in table one Product No. not sory by (A,B,C) but it alternate (Example C,A,B or A,C,B) (See green hightlight) 2. How can I get it on table 4 ? From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]mailto:[mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Friday, September 07, 2012 9:30 PM To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ MMULT functions questions Use this as array =MMULT(OFFSET(INDEX($A$3:$A$5,MATCH(A23,$A$3:$A$5,0),1),,1,1,4),$B$9:$F$12) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]mailto:[mailto:excel-macros@googlegroups.com] On Behalf Of attapan_chainarongb...@ck-mail.commailto:attapan_chainarongb...@ck-mail.com Sent: 07 September 2012 5:07 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: $$Excel-Macros$$ MMULT functions questions Dear All expert Please help me to find the answer. 1. Table1(BOM) and Table2(Forecast) 2. I used MMULT to get matrix value( array1 * array2) = table3 3. Please see table4 (If Part not sort by (A,B,C) but It alternate by (C,A,B) 4. How can I get this answers(table4) Please advise me Rdgs -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.commailto:excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
RE: $$Excel-Macros$$ Need help - To divide the string into three parts
Hi Mangesh, I've read your other replies, and as to why you haven't received a formula method -- most people don't want to take the trouble on a volunteer basis to provide a more complex or difficult solution to a given problem when simple solutions exist. Also in business, the simplest solution is the best value. But I understand that in learning all aspects of a program, sometimes the exercise of solving a problem in various ways is useful. I will provide a formula solution for you. Although it could be solved several ways, I prefer using an array formula, since it can be written in such a way that it can handle a string of text with any number of commas, whereas non-array solutions would be limited to a set maximum. However, even with the array solution, and even though the array will contain all of the parts of the text string, you will only see on your spreadsheet as many parts as there are cells in the area you place the array formula (there are ways to use array formulas with too large of arrays to display on your spreadsheet ,as part of other formulas, that are useful; for example extracting certain values matching a condition, or summarizing the data (in your data, you might want to know how many Mumbais there are, how many 32145s, etc.), without actually displaying in multiple columns all the split data. .Select any cell on row 2 of your spreadsheet, then create the following defined names using the Name Manager (formulas tab in Excel 2007+). I recommend making them Sheet-level names rather than the default Workbook-level. 1. Name =$A2 2. _Name.Terminated =Name, 3. _Name.ColumnIdx =TRANSPOSE(ROW(INDIRECT(1:LEN(_Name.Terminated)-LEN(SUBSTITUTE(_Name.Term inated,,,) 4. _Name.StartPositions =IF(Name.ColumnIdx1,FIND(CHAR(1),SUBSTITUTE(Name,,,CHAR(1),_Name.ColumnId x-1)))+1 5. _Name.StopPositions =FIND(CHAR(1),SUBSTITUTE(_Name.Terminated,,,CHAR(1),_Name.ColumnIdx))-1 6. Name.Columns =MID(Name,_Name.StartPositions,_Name.StopPositions-_Name.StartPositions+1) The purpose of using the defined names is to simplify the formula by breaking it into steps. Insofar as the steps are referred to more than once in the formula, it should make the formula faster to evaluate too. Name.Columns is the culmination of our calculation and results in an array containing each comma-separated value from column A, divided into separate columns. .To display the column-separated values on your spreadsheet, enter the following formula in B2: =Name.Columns .Then highlight from B2 to the furthest column on row 2 needed to display the maximum number of values ever expected. For a maximum of 3 values, highlight B2:D2, or for maximum of 10, B2:K2, etc. .Then hit F2 (edit cell) and Ctrl-Shift-Enter (confirm array formula). This confirms a multi-cell array formula over the selected cells. .Copy the array-entered range from row 2 (e.g. B2:D2) to every other row in your table. Hope this is of interest, Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mangesh Vimay Sent: Monday, September 10, 2012 4:04 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help - To divide the string into three parts Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : Inline image 1 Waiting for your response. Thanks. -- With regards, MaNgEsH -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
RE: $$Excel-Macros$$ detecting loggedin user
Hi Midhun, I like Paul's thorough response. I thought I'd mention that there is a simpler / easier-to-remember way of detecting the logged-in user's name from a macro: Function ReturnUserName() As String UserName = Environ(USERNAME) End Function It is slightly less secure, since the environment variable could be fairly easily modified by a knowledgeable user (in other words Paul's method is actually preferable). But no security you implement in Excel will be high security anyway. If the data you are hiding is of an actual confidential nature, I would recommend instead using a macro to generate a copy of the spreadsheet that only contains the data for a single user, and sending that to the end-user. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: Monday, September 10, 2012 12:06 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ detecting loggedin user Here's something I threw together from macros I already had. I didn't spend too much time on it. I hope they have what you're looking for. There are several things you MENTIONED that I tried to include. Since you want the user to view ONLY his performance, I added filters to the YTD Output sheet and protected it with a password testpassword. (you can change it to whatever you wish) The file should be saved with only blank rows displayed and password protected. You'll also want to password protect your VBA project so that the users won't be able to open the VBEditor and read the sheet password. When the user opens the file, it determines the user's ID based on his/her Windows login. It then updates the Userid in the YTD Performance sheet. A change Event on this sheet checks for a changed userid and calls a function that unprotects the Output sheet, changes the filter to include only the userid, then re-protects the sheet. hope this gives you enough to work with to complete your task. Paul - Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can. - John Wesley - _ From: Midhun Thampan midhun.tham...@gmail.com To: excel-macros@googlegroups.com Sent: Mon, September 10, 2012 1:04:27 PM Subject: $$Excel-Macros$$ detecting loggedin user Hi All; This is a excel file which has a database which will be locked. Just need a code tht will detect only the information of user who logs on the computer. Our system is logged in via 5 digit userid so as someone opens this file his userid should detected so tht he can only view his particular performance.. Kindly help, i tried but did not work. -- Midhun -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To
Re: $$Excel-Macros$$ RE: SAP FICO group
Anil Narayan Gawli Mb:-09769855615 gawli_anil8...@yahoo.co.in gawlianil8...@gmail.com On Mon, Sep 10, 2012 at 1:40 PM, Anil Bhange anil.bha...@tatacommunications.com wrote: Hi All, ** ** First of all thanks to all experts who helping to the world with their expertise knowledge and giving such a big opportunity to learn Excel and VBA so closely. ** ** I also wanted to learn similar kind of logics and participate in discussion for gaining knowledge of SAP FI CO Module, if you aware about such kind of groups can you please share their email ID. ** ** Regards,Anil Bhange IP Phone – 800105 | Mobile - +31 6 1192 3971 ** ** -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Need VBA code for Formatting chart
Dear Rajan, Thanks for suggestion for formatting color Chart VBA but it is not useful for me.I need VBA for separate criteria if change value color then change in chart value color,If change bar color data then change bar color so on... Pls help anybody for solution me Thanks Amar On Thu, Sep 6, 2012 at 6:42 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Download code from here* http://www.excelfox.com/forum/f12/color-chart-series-vba-58/** * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *amar takale *Sent:* 06 September 2012 10:45 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need VBA code for Formatting chart ** ** ** ** -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ help on Power point
Dear Expert. Please tell me how can i re-size all slide in one time.. Regard Manoj -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Stock management software in excel
Dear all, Any stock management macro in excel then Please give me the same. Thanks Regards, Sagar Kasangottuwar -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.