$$Excel-Macros$$ Kindly assist with a formula !!!
Hi Frndz, It would be much appreciated if someone could help me create a spreadsheet whereby if I type "Desk" in cell C1, "Fire Damper" in cell C2, "Fire Sprinkler" in cell C3, and "Garden Sprinkler" in cell C4, then type "Fire Sprinkler" in cell A1, it will search for the words "Fire" and "Sprinkler" in cells C1:C4 and return all the possible matches (i.e. fire sprinkler, garden sprinkler, fire damper) from that column in the form of a drop-down list in cell B1. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Need help with excel formula !!!
Hello Team, Can someone assist me with the excel formula based on the criteria from B44 to B50, PFA the excel file. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. RX Obligation111.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Automatic color for excel chart levels
Hi Experts, Is there any way that chart level colors will be changed automatically, say when it's negative value it should be in Red color and vice versa as Green color. [image: Inline image 1] -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Data mapping tutorials
Hi All, Can anyone would like to provide me an Excel data mapping tutorial with various formulas and functions. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Need a small help in VBA coding
Thanks a lot Ravinder. :) On Wed, May 28, 2014 at 1:24 PM, Ravinder ravindervbacli...@gmail.comwrote: You can use something like this, u just need again navigate browser with same link (test.com), I think It will open a new blank form (see yellow part) Sub test() Dim IEApp As New InternetExplorer ' Set IEApp = CreateObject(InternetExplorer.Application) IEApp.Visible = True IEApp.Navigate www.amazon.com ' here is the real link, I will add it later Do: Loop Until IEApp.Busy = False Do: Loop Until IEApp.Busy = False With IEApp.Document Do: Loop Until .ReadyState = complete ' till here everything is fine For Each cel In Range(B5:B999) ' i tried this to make him search in range B for columns, but he is checking all columns at once, not one by one If cel = x Then ' if marked with x, he should start filling out the web form: .getelemenstbyid(SEL_SENSOR).selectedindex = 1 .getelemenstbyid(TXT_TITEL).Value = ActiveCell.Offset(0, 3).Value ' these are the automated fillings I already put them in, they worked. But he always uses the first row, not the row with an x .getelemenstbyid(TXT_BESCHREIBUNG).Value = ActiveCell.Offset(0, 4).Value .getelemenstbyid(adrEntwBezeichnungId).Value = ActiveCell.Offset(0, 6).Value .getelemenstbyid(TXT_ADR_MODUL_ID).Value = ActiveCell.Offset(0, 8).Value .getelemenstbyid(SEL_BEWERTUNGS_INDEXE).selectedindex = ActiveCell.Offset(0, 5).Value .getelementbyid(IMG_REFRESHPROJEKTLISTE).Click ' this is the submit line, already works fine Do While IEApp.Busy Or IEApp.ReadyState READYSTATE_COMPLETE DoEvents Loop IEApp.Navigate test.com Do While IEApp.Busy Or IEApp.ReadyState READYSTATE_COMPLETE DoEvents Loop ' after using a row with x, he should now close the window, open a new one and start doing the same with the next row with an x End If Next End With End Sub *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Wednesday, May 28, 2014 5:07 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need a small help in VBA coding Hi All, I just need a small favor from your end, please have a look at the code I have explained everything over there. My requirement is as follows; Its just a popup with blank forms, the forms need to be filled with the data from rowx and columns E-L I already managed to getelementbyid from the source code and fill them with the text from columns E-L. this is not the problem. *The problem is, that he always takes the data from the first row, even when there is no x in the B column.* Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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
$$Excel-Macros$$ Need a small help in VBA coding
Hi All, I just need a small favor from your end, please have a look at the code I have explained everything over there. My requirement is as follows; Its just a popup with blank forms, the forms need to be filled with the data from rowx and columns E-L I already managed to getelementbyid from the source code and fill them with the text from columns E-L. this is not the problem. *The problem is, that he always takes the data from the first row, even when there is no x in the B column.* Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. test.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Need an address split up formula.....
Thanks a lot Jayavelu. :) *Thanks! Indrajit* On Thu, Mar 13, 2014 at 1:01 PM, JAYAVELU SUN jayavelu@gmail.comwrote: This is solution for State =MID((RIGHT(A17,8)),1,3) this is solution of pin code =right(right(A17,4) On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai talk2indra...@gmail.comwrote: Hi Experts, Is there any way out to split up an address as per the attached file format! If so then please provide me the formula or vba code (anything). Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Need an address split up formula.....
Thanks Shahzad. On Mon, Mar 17, 2014 at 12:04 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Hi Indrajit, try this =IF(ISERR(FIND(ACT,A4,FIND(ACT,A4)+1)),LEFT(A4,FIND(ACT,A4)-1),LEFT(A4,FIND(ACT,A4,FIND(ACT,A4)+1)-1)) On Mon, Mar 17, 2014 at 12:32 AM, Indrajit $nai talk2indra...@gmail.comwrote: Thanks Ashish. On Sun, Mar 16, 2014 at 8:56 PM, ashish koul koul.ash...@gmail.comwrote: then try left and find function combined On Sun, Mar 16, 2014 at 1:02 AM, Indrajit $nai talk2indra...@gmail.comwrote: Yes Ashish... On Sat, Mar 15, 2014 at 3:39 PM, ashish koul koul.ash...@gmail.comwrote: is ACT common in all On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai talk2indra...@gmail.com wrote: Hi Experts, Is there any way out to split up an address as per the attached file format! If so then please provide me the formula or vba code (anything). Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed
Re: $$Excel-Macros$$ Need an address split up formula.....
Thanks Ashish. On Sun, Mar 16, 2014 at 8:56 PM, ashish koul koul.ash...@gmail.com wrote: then try left and find function combined On Sun, Mar 16, 2014 at 1:02 AM, Indrajit $nai talk2indra...@gmail.comwrote: Yes Ashish... On Sat, Mar 15, 2014 at 3:39 PM, ashish koul koul.ash...@gmail.comwrote: is ACT common in all On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai talk2indra...@gmail.comwrote: Hi Experts, Is there any way out to split up an address as per the attached file format! If so then please provide me the formula or vba code (anything). Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros
Re: $$Excel-Macros$$ Need an address split up formula.....
Yes Ashish... On Sat, Mar 15, 2014 at 3:39 PM, ashish koul koul.ash...@gmail.com wrote: is ACT common in all On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai talk2indra...@gmail.comwrote: Hi Experts, Is there any way out to split up an address as per the attached file format! If so then please provide me the formula or vba code (anything). Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Need an address split up formula.....
Hi Experts, Is there any way out to split up an address as per the attached file format! If so then please provide me the formula or vba code (anything). Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Address split up.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need a professional MIS Report.....
Thanks Priyanka. On Sun, Dec 15, 2013 at 6:56 PM, Priyanka Sachdeva priyanka.sachdeva...@gmail.com wrote: Indrajit, Try the below link http://chandoo.org/wp/excel-dashboards/ One of the better sites for Dashboard templates. Helped me put together something similar a couple of months back Regards, Priyanka S On Sat, Dec 14, 2013 at 10:32 PM, Indrajit $nai talk2indra...@gmail.comwrote: Hi Experts, I have a report (excel file) that shows the number of calls by hour over the last 6 weeks. I would like this rolled up and broken down to show the percentage of weekly call volume broken down by hour per day. Essentially, take an average of every hour for the 6 weeks and then put that average in a one week time frame to show what % of total calls for a week would be expected in that hour block for everyday. This report doesn't include hours when we did not receive calls. Thanks in advance. Thanks Regards, Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit
$$Excel-Macros$$ Need a professional MIS Report.....
Hi Experts, I have a report (excel file) that shows the number of calls by hour over the last 6 weeks. I would like this rolled up and broken down to show the percentage of weekly call volume broken down by hour per day. Essentially, take an average of every hour for the 6 weeks and then put that average in a one week time frame to show what % of total calls for a week would be expected in that hour block for everyday. This report doesn't include hours when we did not receive calls. Thanks in advance. Thanks Regards, Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Call Volume 11.1.13 through 12.13.13.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ How do I decrease the size of this file.....
Thanks to all of you. On Sun, Dec 8, 2013 at 4:01 AM, Amit Desai (MERU) amit.de...@merucabs.comwrote: I have converted the file in .xlsb version. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 08 December 2013 13:45 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ How do I decrease the size of this file. Hi All, Kindly assist me how do I decrease the size of the attached file. Please let me know the procedure as well. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- 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. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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
$$Excel-Macros$$ Need help to create a Purchase Order database.....
Hi Experts, PFA both the files. 1. Purchase order template 2. Database *Requirement:* - I want to create a Purchase Order file database, suppose if I enter something in the purchase order file and save the same (you can create a button) then it will save in the Database file. - In the Database file some columns headings are marked in GREEN, which I want to incorporate in the Purchase Order file as well, kindly make the necessary changes in the Purchase Order file. Hope I am clear enough, if you want any further clarification then please feel free to contact me. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Database.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet Purchase Order.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need PDF to Excel Converter.....
Hi Ravinder, There is no doubt that it's really help me a lot and kudos to you. :) Thanks Regards, Indrajit On Fri, Nov 8, 2013 at 2:25 PM, Ravinder ravinderexcelgr...@gmail.comwrote: May be this help you…pfa *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Friday, November 08, 2013 2:39 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need PDF to Excel Converter. Ravinder, need a small edit on this, have to add Company name, Preferred Ph no. and Cell Ph No. along with the other heads. PFA the requirement. Thanks in advance. -- Indrajit On Fri, Nov 8, 2013 at 1:41 AM, Indrajit $nai talk2indra...@gmail.com wrote: Ravinder, you are the best, you always help me out from the critical situations. Hats off to you!!! and it's really amazing. If I need any further clarification / modification, definitely I'll get back to you, hope you wouldn't mind. :) Thanks Regards, Indrajit On Thu, Nov 7, 2013 at 4:00 AM, Ravinder ravinderexcelgr...@gmail.com wrote: PFA.. I have copied PDF data in second sheet and then click on button. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Thursday, November 07, 2013 1:01 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need PDF to Excel Converter. Hi Experts, Need help to convert PDF to Excel, like the attached file. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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
Re: $$Excel-Macros$$ Need PDF to Excel Converter.....
Ravinder, you are the best, you always help me out from the critical situations. Hats off to you!!! and it's really amazing. If I need any further clarification / modification, definitely I'll get back to you, hope you wouldn't mind. :) Thanks Regards, Indrajit On Thu, Nov 7, 2013 at 4:00 AM, Ravinder ravinderexcelgr...@gmail.comwrote: PFA.. I have copied PDF data in second sheet and then click on button. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Thursday, November 07, 2013 1:01 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need PDF to Excel Converter. Hi Experts, Need help to convert PDF to Excel, like the attached file. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Help required in a small formula.....
Hello Experts, Kindly find attached the file, and can anyone please explain me why the results are comming different by using the same kind of formula in the column no. E2 and E4? Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Formula error.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Help required in formula.....
*Wow! you are amazing met. :)* -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Fri, Oct 4, 2013 at 2:09 AM, Ravinder ravinderexcelgr...@gmail.comwrote: PFA ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Friday, October 04, 2013 7:13 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help required in formula. ** ** Hi Ravinder, ** ** Actually it was my mistake, I don't wanna count it, I want to sum up those nos as per the region headings. ** ** PFA the two files for further reference. ** ** ** ** -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. ** ** On Thu, Oct 3, 2013 at 5:36 AM, Ravinder ravinderexcelgr...@gmail.com wrote: Pfa, as an example of your query of country cnt *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Thursday, October 03, 2013 2:22 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help required in formula. Hi Experts / Ravinder, Need another small help. PFA. I want to count the countries (col B) as per the Region head, from Col (E to J). Kindly find attached the Roughs file for your reference. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Thu, Oct 3, 2013 at 1:59 PM, Indrajit $nai talk2indra...@gmail.com wrote: Hey, Ravinder it's really great, thanks bro. :) -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Thu, Oct 3, 2013 at 1:31 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Actullay its fuction u have to use as Excel formulas type =sumup(b2) and drag *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Thursday, October 03, 2013 1:29 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help required in formula. Unable to run the macro, kindly assist. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Thu, Oct 3, 2013 at 12:07 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this udf or pfa Function SUMUP(rng As Range) splitwrd = Split(rng.Value, ,) For Each word In splitwrd fword = InStr(1, word, () sword = InStr(fword, word, )) SUMUP = SUMUP + Int(Mid(word, fword + 1, sword - 1 - fword)) Next End Function *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Thursday, October 03, 2013 5:56 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Help required in formula. Hi Experts, PFA, kindly let me know is there any formula to sum-up the col B nos into col D. As of now I am doing it manually, but it's very long term process! Kindly let me
Re: $$Excel-Macros$$ Help required in formula.....
Hey, Ravinder it's really great, thanks bro. :) -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Thu, Oct 3, 2013 at 1:31 PM, Ravinder ravinderexcelgr...@gmail.comwrote: Actullay its fuction u have to use as Excel formulas type =sumup(b2) and drag ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Thursday, October 03, 2013 1:29 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help required in formula. ** ** Unable to run the macro, kindly assist. ** ** ** ** -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. ** ** ** ** On Thu, Oct 3, 2013 at 12:07 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Try this udf or pfa Function SUMUP(rng As Range) splitwrd = Split(rng.Value, ,) For Each word In splitwrd fword = InStr(1, word, () sword = InStr(fword, word, )) SUMUP = SUMUP + Int(Mid(word, fword + 1, sword - 1 - fword)) Next End Function *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Thursday, October 03, 2013 5:56 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Help required in formula. Hi Experts, PFA, kindly let me know is there any formula to sum-up the col B nos into col D. As of now I am doing it manually, but it's very long term process! Kindly let me know is there any way out to do it through any formula. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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
$$Excel-Macros$$ Help required in formula.....
Hi Experts, PFA, kindly let me know is there any formula to sum-up the col B nos into col D. As of now I am doing it manually, but it's very long term process! Kindly let me know is there any way out to do it through any formula. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Help required.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: FW: $$Excel-Macros$$ Need experts help ***URGENT***
Thanks Ravinder for your kind help. I have not checked it yet, but if I face any issue, definitely I'll get back to you for further assistance, hope you would't mind. :) Thanks Regards, Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Tue, Sep 24, 2013 at 2:21 PM, Ravinder ravinderexcelgr...@gmail.comwrote: Try this. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Tuesday, September 24, 2013 1:40 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need experts help ***URGENT*** ** ** Hi Guys, Kindly find attached the slave file, actually it's same as the master file. ** ** ** ** Thanks Regards, Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Tue, Sep 24, 2013 at 12:07 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Could u pls provide the specific file (slave) in which you are facing this prob. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Tuesday, September 24, 2013 3:48 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need experts help ***URGENT*** *Hi Experts / Ravinder / Anil,* I need a small update on that file, which you guys had updated. I need to collect data from almost 500 + files, and the macro is doing it's job pretty well. :) But facing a new issue, suppose I am collecting this data from the slave files on readonly mode, but whenever closing this slave files, the master file getting a pop-up message, now you can open the file . Read-write mode or Read-only mode, this is slowing up (hanging) master file data collecting work. :( Can you guys have a quick glance on it and making it bit more user friendly. Thanks in advance for all of your support and valuable time. Thanks Regards, Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Thu, Sep 19, 2013 at 1:54 PM, Indrajit $nai talk2indra...@gmail.com wrote: Thanks a lot bro. :D It works like a charm. :D -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Thu, Sep 19, 2013 at 12:53 PM, Ravinder ravinderexcelgr...@gmail.com wrote: Pfa….. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Thursday, September 19, 2013 12:49 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need experts help ***URGENT*** Both of you are simply AWESOME!!! Just need a small change, I actually want consolidate a particular range from the salve files, like from A3:L3, not the whole file, actually it's consolidating the whole file! Guys can you do some changes on it, and revert me the same. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful
Re: $$Excel-Macros$$ Need experts help ***URGENT***
*Hi Experts / Ravinder / Anil,* I need a small update on that file, which you guys had updated. I need to collect data from almost 500 + files, and the macro is doing it's job pretty well. :) But facing a new issue, suppose I am collecting this data from the slave files on readonly mode, but whenever closing this slave files, the master file getting a pop-up message, now you can open the file . Read-write mode or Read-only mode, this is slowing up (hanging) master file data collecting work. :( Can you guys have a quick glance on it and making it bit more user friendly. Thanks in advance for all of your support and valuable time. Thanks Regards, Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Thu, Sep 19, 2013 at 1:54 PM, Indrajit $nai talk2indra...@gmail.comwrote: Thanks a lot bro. :D It works like a charm. :D -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Thu, Sep 19, 2013 at 12:53 PM, Ravinder ravinderexcelgr...@gmail.comwrote: Pfa….. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Thursday, September 19, 2013 12:49 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need experts help ***URGENT*** ** ** Both of you are simply AWESOME!!! ** ** Just need a small change, I actually want consolidate a particular range from the salve files, like from A3:L3, not the whole file, actually it's consolidating the whole file! ** ** Guys can you do some changes on it, and revert me the same. ** ** Thanks in advance. ** ** -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. ** ** ** ** ** ** On Thu, Sep 19, 2013 at 4:33 AM, Indrajit $nai talk2indra...@gmail.com wrote: Hi Experts, ** ** I am facing some problem with this macro file, actually the macro is running pretty well, but need some changes on it, which I am not able to do, kindly try to sort out the below requirements: ** ** 1. Suppose I have too many files with the same column headers (like the master file) in a particular folder, but I just want to copy the data from Cell A3:L3 (from each files) and paste it in the master tracker (PFA).*** * ** ** 2. If the some of the slave files are in read-only mode, still the master fill will be able to copy and paste the data from all the slave files. ** ** Thanks in advance for your kind support. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop
Re: $$Excel-Macros$$ Need experts help ***URGENT***
Both of you are simply AWESOME!!! Just need a small change, I actually want consolidate a particular range from the salve files, like from A3:L3, not the whole file, actually it's consolidating the whole file! Guys can you do some changes on it, and revert me the same. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Thu, Sep 19, 2013 at 4:33 AM, Indrajit $nai talk2indra...@gmail.comwrote: Hi Experts, I am facing some problem with this macro file, actually the macro is running pretty well, but need some changes on it, which I am not able to do, kindly try to sort out the below requirements: 1. Suppose I have too many files with the same column headers (like the master file) in a particular folder, but I just want to copy the data from Cell A3:L3 (from each files) and paste it in the master tracker (PFA). 2. If the some of the slave files are in read-only mode, still the master fill will be able to copy and paste the data from all the slave files. Thanks in advance for your kind support. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Need experts help ***URGENT***
Thanks a lot bro. :D It works like a charm. :D -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Thu, Sep 19, 2013 at 12:53 PM, Ravinder ravinderexcelgr...@gmail.comwrote: Pfa….. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Thursday, September 19, 2013 12:49 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need experts help ***URGENT*** ** ** Both of you are simply AWESOME!!! ** ** Just need a small change, I actually want consolidate a particular range from the salve files, like from A3:L3, not the whole file, actually it's consolidating the whole file! ** ** Guys can you do some changes on it, and revert me the same. ** ** Thanks in advance. ** ** -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. ** ** ** ** ** ** On Thu, Sep 19, 2013 at 4:33 AM, Indrajit $nai talk2indra...@gmail.com wrote: Hi Experts, ** ** I am facing some problem with this macro file, actually the macro is running pretty well, but need some changes on it, which I am not able to do, kindly try to sort out the below requirements: ** ** 1. Suppose I have too many files with the same column headers (like the master file) in a particular folder, but I just want to copy the data from Cell A3:L3 (from each files) and paste it in the master tracker (PFA). ** ** 2. If the some of the slave files are in read-only mode, still the master fill will be able to copy and paste the data from all the slave files. ** ** Thanks in advance for your kind support. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. ** ** ** ** -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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
Re: $$Excel-Macros$$ Validation through Macro!!!
Thanks a lot for your help. Sure it will help me a lot, but if I stuck somewhere then definitely I'll get back to you. On Sat, Jul 6, 2013 at 5:54 PM, vba v...@vabs.in wrote: Hi Indrajit, You have asked something diff.. PFA sheet where i have set restrictions for few cases.. I hope you can manage show for rest cases.. Let me know if you need further help. How it works: Set min max value in sheet 1 error message . As soon as you select any cell in sheet 2, cell will display Guidelines as entered in sheet 1 will apply restrictions too with error message. Cheers!! On Mon, Jul 1, 2013 at 12:21 AM, Indrajit $nai talk2indra...@gmail.comwrote: Hi All, PFA. I want to create the validation through Macro, can the EXPERTS help me on this? Requirement is on the 1st sheet and the Table data is on the 2nd sheet. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members
$$Excel-Macros$$ Validation through Macro!!!
Hi All, PFA. I want to create the validation through Macro, can the EXPERTS help me on this? Requirement is on the 1st sheet and the Table data is on the 2nd sheet. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Validation help.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Need some Defect chart / Control chart.....
Hi All, How many Control chart / Defect chart are there in a Business to identify Business / Process defect? I know some of them, like Pareto analysis, Fishbone diagram, but are there any other chart is available to measure the defect? If so, then please provide me some samples. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ please provide me some basic training materials of Excel
Hi all, please provide me some basic training materials of Excel . thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ please provide me some basic training materials of Excel
Thanks to all of you. :) On Tue, Mar 5, 2013 at 11:04 AM, yhan a yhan2...@gmail.com wrote: Thank you for the help Kuldeep Singh. Ian On Tue, Mar 5, 2013 at 1:28 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi, PFA.. Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Tue, Mar 5, 2013 at 10:53 AM, yhan a yhan2...@gmail.com wrote: Hi guys, Really impressed with all your in-depth knowledge on vba. I really want to learn how to program like vba, unfortunately my lack of background on computer program prevents me from learning. Pls. email me a basic guide for vba programming or any sort of beginner's guide for vba. I will greatly appreciate all your help. Thank you. Ian On Tue, Mar 5, 2013 at 12:40 PM, Kuldeep Singh naukrikuld...@gmail.comwrote: Hi Indrajit, PFA Regards, Kuldeep Singh Info Edge India Limited (naukri.com) Phone.: +91-0120-4841100, Extn.: 2467, 9716615535 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Mon, Mar 4, 2013 at 10:34 PM, Maries talk2mar...@gmail.com wrote: Hi, http://www.youtube.com/user/excelisfun http://people.highline.edu/mgirvin/ExcelIsFun.htm On Mon, Mar 4, 2013 at 7:32 PM, xlstime xlst...@gmail.com wrote: try this http://www.free-training-tutorial.com/ On Mon, Mar 4, 2013 at 8:35 PM, Indrajit $nai talk2indra...@gmail.com wrote: Hi all, please provide me some basic training materials of Excel . thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- . Enjoy Team XLS -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en . For more options, visit https://groups.google.com/groups/opt_out. -- * * * MARIES* Excel Inspiration http://xcel-inspiration.blogspot.com/ -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page
$$Excel-Macros$$ Re: Login and Logout time tracker...need help....
Sorry attached wrong file, in my previous mail... On Tue, Feb 19, 2013 at 8:09 PM, Indrajit $nai talk2indra...@gmail.comwrote: Hi Experts, Need a small help from your end. I've created a login and logout time tracker, which is working perfectly, but I want to show running login hrs in this file, as of now it's showing running current time, as per system clock, which is ok, but I wanna show running login hrs instate of running current time. If it's possible then please provide me the VBA code. PFA for your reference. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Indrajit Snai +91 9051755745 talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. Login_Logout.xlsm Description: Binary data
Re: $$Excel-Macros$$ Re: Login and Logout time tracker...need help....
*Thanks Paul, thanks a lot, it's just perfect. :)* On Tue, Feb 19, 2013 at 8:42 PM, Paul Schreiner schreiner_p...@att.netwrote: you should be able to subtract the login time from the current date/time (now()) and format it as hh:nn:ss using: ThisWorkbook.Sheets(2).Range(k20).Value = Format(Now() - Sheets(2).Range(i9).Value, hh:nn:ss) *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:* Indrajit $nai talk2indra...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, February 19, 2013 3:13:23 PM *Subject:* $$Excel-Macros$$ Re: Login and Logout time tracker...need help Sorry attached wrong file, in my previous mail... On Tue, Feb 19, 2013 at 8:09 PM, Indrajit $nai talk2indra...@gmail.comwrote: Hi Experts, Need a small help from your end. I've created a login and logout time tracker, which is working perfectly, but I want to show running login hrs in this file, as of now it's showing running current time, as per system clock, which is ok, but I wanna show running login hrs instate of running current time. If it's possible then please provide me the VBA code. PFA for your reference. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom
Re: $$Excel-Macros$$ Re: Login and Logout time tracker...need help....
Thanks Paul. :) On Tue, Feb 19, 2013 at 10:28 PM, Paul Schreiner schreiner_p...@att.netwrote: Sorry, you're not going to get around THAT one. Basically, you have an Excel file (this login/logout file) that is taking over your CPU cycles every second to update the sheet. If you open another Excel file, those silly people at Microsoft think that you want to WORK on the newly opened excel file and therefore give it the highest priority! Normally, the file you're WORKING on is more important than the one you're no longer paying attention to! which means that the OTHER processes are put into the background. you MIGHT be able to change the windows priority and have it keep some measure of priority, but based on what I've come across, you're not going to keep it from doing that. Excel just wasn't intended to be used as a real-time clock. sorry, *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:* Indrajit $nai talk2indra...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, February 19, 2013 5:12:33 PM *Subject:* Re: $$Excel-Macros$$ Re: Login and Logout time tracker...need help Hi Paul, There is one problem, whenever I'm opening any new excel file, then the login hr countdown get stuck!! Please assist me with a proper solution. Thanks. On Tue, Feb 19, 2013 at 9:07 PM, Indrajit $nai talk2indra...@gmail.comwrote: *Thanks Paul, thanks a lot, it's just perfect. :)* On Tue, Feb 19, 2013 at 8:42 PM, Paul Schreiner schreiner_p...@att.netwrote: you should be able to subtract the login time from the current date/time (now()) and format it as hh:nn:ss using: ThisWorkbook.Sheets(2).Range(k20).Value = Format(Now() - Sheets(2).Range(i9).Value, hh:nn:ss) *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:* Indrajit $nai talk2indra...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, February 19, 2013 3:13:23 PM *Subject:* $$Excel-Macros$$ Re: Login and Logout time tracker...need help Sorry attached wrong file, in my previous mail... On Tue, Feb 19, 2013 at 8:09 PM, Indrajit $nai talk2indra...@gmail.comwrote: Hi Experts, Need a small help from your end. I've created a login and logout time tracker, which is working perfectly, but I want to show running login hrs in this file, as of now it's showing running current time, as per system clock, which is ok, but I wanna show running login hrs instate of running current time. If it's possible then please provide me the VBA code. PFA for your reference. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel
$$Excel-Macros$$ Web page import / export through macro !!!!!
Hi All, I wanna import / export webpage content through macro, if it is possible through VBA coding then plz provide me the VBA code. Kindly chk the attached file for your reference. *My requirement:* Actually I'm able to import the webpage content through the attached file, but I am not not able to export any excel data to the particular webpage, like if I write the user name in the excel file it will copy from the excel file then it will paste in the particular webpage and after that it will import the full webpage content in the excel file, like an automated form filling software. I have link my excel file with Gmail Account creation webpage, if u want u can change it to any other website. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Web.xlsm Description: Binary data
$$Excel-Macros$$ File conversion from BMP to XLS !!!!!
Hi All, Is it possible to convert a Bitmap image (BMP) into a Excel file through some Macro? If it is possible then please send me the code. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
*@ Krishna, Sir right now it's working fine.thanks a lot for all your kind support throughout. :) it's really make my job simpler.* * * * * *Thanks Regards,* *Indrajit* * * On Wed, Oct 3, 2012 at 7:27 PM, Indrajit $nai talk2indra...@gmail.comwrote: *@ Krishna, waiting for your reply. :)* On Wed, Oct 3, 2012 at 1:13 AM, Indrajit $nai talk2indra...@gmail.comwrote: *@ Krishna, no Sir; still showing the same error! * On Tue, Oct 2, 2012 at 9:26 PM, Krishna Kumar krishnak...@gmail.comwrote: .Range(b LastRow).Resize(, 4) = Split(Me.TextBox2.Value | Me.TextBox1.Value | Me.TextBox3.Value | Me.TextBox4.Value, |) Kris ExcelFox -- 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$$ Rajan Verma - Most Helpful Member September 2012
*Congrats bro. :)* * * On Wed, Oct 3, 2012 at 11:35 AM, SAGAR KASANGOTTUWAR sagarkasangottu...@gmail.com wrote: Congrats Rajan On Wed, Oct 3, 2012 at 10:36 AM, Karan Singh karan1...@gmail.com wrote: Congrats dude! Karan Singh On Wed, Oct 3, 2012 at 10:24 AM, Aamir Shahzad aamirshahza...@gmail.comwrote: Congrates Rajan Aamir Shahzad On Wed, Oct 3, 2012 at 9:50 AM, Kuldeep Singh naukrikuld...@gmail.comwrote: Congratulations Rajan Sir. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.com) Phone.: +91-120-4763789, Extn.: 789, 971615535 naukrikuld...@gmail.com || www.naukri.com || www.naukrigulf.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Tue, Oct 2, 2012 at 11:32 PM, Christi Jacob christi.ja...@gmail.com wrote: Congrats Rajan, Worthy winner! CVJ On Tue, Oct 2, 2012 at 9:40 PM, v...@vabs.in wrote: Congrats... Rajan.. Keep it up buddy by sharing your exceptional knowledge.. Rgds//Vabs Sent on my BlackBerry® from Vodafone -- *From: *Rajan_Verma rajanverma1...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Tue, 2 Oct 2012 21:38:08 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *RE: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012 *Thank you sam.* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Sam Mathai Chacko *Sent:* 02 October 2012 9:35 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Rajan Verma - Most Helpful Member September 2012 ** ** Congratulations Rajan Regards, Sam On Tue, Oct 2, 2012 at 9:03 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Rajan Verma has been selected as 'Most Helpful Member' for the month of Sep'12. He has posted 137 posts in last month and helped forum members through his excel expertise. I truly appreciate his knowledge, consistency and commitment to the group. * Rajan, please find enclosed the award certificate in honor of your contribution. Congratulations and thanks for your contribution.* Thanks to Vabz, Don, Paul, Prince, Noorain, Kuldeep, David and all other folks for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager P.S. If you have any feedback, please share your thoughts by filling the survey formhttps://docs.google.com/spreadsheet/viewform?fromEmail=trueformkey=dHpYdmtTeWZBcEhDWDhmandNWDlpYXc6MQ. -- 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 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
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
*@ Krishna, waiting for your reply. :)* On Wed, Oct 3, 2012 at 1:13 AM, Indrajit $nai talk2indra...@gmail.comwrote: *@ Krishna, no Sir; still showing the same error! * On Tue, Oct 2, 2012 at 9:26 PM, Krishna Kumar krishnak...@gmail.comwrote: .Range(b LastRow).Resize(, 4) = Split(Me.TextBox2.Value | Me.TextBox1.Value | Me.TextBox3.Value | Me.TextBox4.Value, |) Kris ExcelFox -- 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$$ Required help in Work Allocation VBA based excel file.
*@ Krishna, but Sir, still it's showing the same error!!!* On Tue, Oct 2, 2012 at 4:10 PM, Krishna Kumar krishnak...@gmail.com wrote: in this line it should be 3 .Range(b LastRow).Resize(, 3) in your code it's 4 Kris Kris ExcelFox -- 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$$ Required help in Work Allocation VBA based excel file.
*@ Krishna, thanks a lot Sir. Lemme try this :)* On Fri, Sep 28, 2012 at 9:51 PM, Krishna Kumar krishnak...@gmail.comwrote: Hi Replace the commandbutton1 code with this one. Private Sub CommandButton1_Click() Dim wbkActive As Workbook Dim FilePathAs String Dim FileNameAs String Dim wbkOpen As Workbook Dim LastRow As Long If wbkActive Is Nothing Then Set wbkActive = ThisWorkbook FilePath = C:\Users\Indra\Desktop\ If Right(FilePath, 1) \ Then FilePath = FilePath \ If Len(Me.TextBox1.Value) Then If Len(Me.TextBox2.Value) Then If Len(Me.TextBox3.Value) Then FileName = FilePath Me.TextBox3.Value .xlsx Dim r r = Evaluate(match( Me.TextBox3.Value ,'MasterSheet'!B4:B1000,0)) If Not FileIsOpen(FileName) Then Set wbkOpen = Workbooks.Open(FilePath Me.TextBox3.Value .xlsx) With wbkOpen.Worksheets(1) LastRow = .Range(b .Rows.Count).End(3).Row + 1 .Range(a LastRow) = LastRow - 3 .Range(b LastRow).Resize(, 3) = Split(Me.TextBox2.Value , Me.TextBox1.Value , Me.TextBox3.Value, ,) End With wbkOpen.Close 1 Set wbkOpen = Nothing MsgBox Done, , ExcelFox.com Unload Me If Not IsError(r) Then Cells(r, f) = Assigned End If Else MsgBox Workbook ' FileName ' is already opened vbLf Close the workbook and try again, vbInformation, ExcelFox.com If Not IsError(r) Then Cells(r, f) = Unassigned End If Exit Sub End If Else MsgBox Emp ID is missing, vbInformation, ExcelFox.com Me.TextBox3.SetFocus End If Else MsgBox Batch No is missing, vbInformation, ExcelFox.com Me.TextBox2.SetFocus End If Else MsgBox Site is missing, vbInformation, ExcelFox.com Me.TextBox1.SetFocus End If End Sub 1. Through this Master file I'm able to create the slave files, but it's not opening, showing an error invalid format. I'm not sure how you create the slave files. So I can't comment on that. 3. In the Master file Batch Assign to and Batch Status is not updating after assigning any Batch to the slave file. See the code above. Kris ExcelFox -- 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$$ Required help in Work Allocation VBA based excel file.
*@ Krishna, Sir I'm waiting for your reply. :)* * * On Thu, Sep 27, 2012 at 2:38 AM, Indrajit $nai talk2indra...@gmail.comwrote: *@ Krishna, Sir I'm waiting for your reply. :)* On Tue, Sep 25, 2012 at 11:16 PM, Indrajit $nai talk2indra...@gmail.comwrote: *@ Krishna, thanks for the reply, It working now, but some issue;* * * *1. Through this Master file I'm able to create the slave files, but it's not opening, showing an error invalid format.* *2. If the file is created before, then the data is saving in those slave files, which is ok.* *3. In the Master file Batch Assign to and Batch Status is not updating after assigning any Batch to the slave file.* * * *You have done a lot for me; please do a little more; then this will be a perfect tool to work with.* * * *Thanks Regards* *Indrajit* * * * * On Tue, Sep 25, 2012 at 10:35 PM, Krishna Kumar krishnak...@gmail.comwrote: Remove any missing libraries via Tool References in the VBE window. Also keep red lines in single line rather than multiple lines Kris On Tue, Sep 25, 2012 at 7:12 PM, Indrajit $nai talk2indra...@gmail.com wrote: @Krishna, thanks for the solution, but one problem is there, when I'm using the below mention code I'm getting an error. PFA the error snapshot. Waiting for your reply. Thanks Regards, Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Mon, Sep 24, 2012 at 5:49 PM, Krishna Kumar krishnak...@gmail.com wrote: Hi Put this code in Userform module. Dim wbkActive As Workbook Private Sub CommandButton1_Click() Dim FilePathAs String Dim FileNameAs String Dim wbkOpen As Workbook Dim LastRow As Long If wbkActive Is Nothing Then Set wbkActive = ThisWorkbook FilePath = wbkActive.Worksheets(1).[i1] If Right(FilePath, 1) \ Then FilePath = FilePath \ If Len(Me.TextBox1.Value) Then If Len(Me.TextBox2.Value) Then If Len(Me.TextBox3.Value) Then FileName = FilePath Me.TextBox3.Value .xlsx If Not FileIsOpen(FileName) Then Set wbkOpen = Workbooks.Open(FilePath Me.TextBox3.Value .xlsx) With wbkOpen.Worksheets(1) LastRow = .Range(b .Rows.Count).End(3).Row + 1 .Range(a LastRow) = LastRow - 3 .Range(b LastRow).Resize(, 3) = Split(Me.TextBox2.Value , Me.TextBox1.Value , Me.TextBox3.Value, ,) End With wbkOpen.Close 1 Set wbkOpen = Nothing MsgBox Done, , ExcelFox.com Unload Me Else MsgBox Workbook ' FileName ' is already opened. vbLf Close the workbook and try again, vbInformation, ExcelFox.com Exit Sub End If Else MsgBox Emp ID is missing, vbInformation, ExcelFox.com Me.TextBox3.SetFocus End If Else MsgBox Batch No is missing, vbInformation, ExcelFox.com Me.TextBox2.SetFocus End If Else MsgBox Site is missing, vbInformation, ExcelFox.com Me.TextBox1.SetFocus End If End Sub Private Sub CommandButton2_Click() Unload Me End Sub Function FileIsOpen(ByVal FileName As String) As Boolean Dim ff As Long On Error GoTo Xit ff = FreeFile() Open FileName For Random Access Read Write Lock Read Write As ff Close ff FileIsOpen = False Exit Function Xit: Close ff FileIsOpen = True End Function In I1 enter the network path. Kris ExcelFox -- 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
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
*@ Krishna, Sir I'm waiting for your reply. :)* On Tue, Sep 25, 2012 at 11:16 PM, Indrajit $nai talk2indra...@gmail.comwrote: *@ Krishna, thanks for the reply, It working now, but some issue;* * * *1. Through this Master file I'm able to create the slave files, but it's not opening, showing an error invalid format.* *2. If the file is created before, then the data is saving in those slave files, which is ok.* *3. In the Master file Batch Assign to and Batch Status is not updating after assigning any Batch to the slave file.* * * *You have done a lot for me; please do a little more; then this will be a perfect tool to work with.* * * *Thanks Regards* *Indrajit* * * * * On Tue, Sep 25, 2012 at 10:35 PM, Krishna Kumar krishnak...@gmail.comwrote: Remove any missing libraries via Tool References in the VBE window. Also keep red lines in single line rather than multiple lines Kris On Tue, Sep 25, 2012 at 7:12 PM, Indrajit $nai talk2indra...@gmail.com wrote: @Krishna, thanks for the solution, but one problem is there, when I'm using the below mention code I'm getting an error. PFA the error snapshot. Waiting for your reply. Thanks Regards, Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Mon, Sep 24, 2012 at 5:49 PM, Krishna Kumar krishnak...@gmail.com wrote: Hi Put this code in Userform module. Dim wbkActive As Workbook Private Sub CommandButton1_Click() Dim FilePathAs String Dim FileNameAs String Dim wbkOpen As Workbook Dim LastRow As Long If wbkActive Is Nothing Then Set wbkActive = ThisWorkbook FilePath = wbkActive.Worksheets(1).[i1] If Right(FilePath, 1) \ Then FilePath = FilePath \ If Len(Me.TextBox1.Value) Then If Len(Me.TextBox2.Value) Then If Len(Me.TextBox3.Value) Then FileName = FilePath Me.TextBox3.Value .xlsx If Not FileIsOpen(FileName) Then Set wbkOpen = Workbooks.Open(FilePath Me.TextBox3.Value .xlsx) With wbkOpen.Worksheets(1) LastRow = .Range(b .Rows.Count).End(3).Row + 1 .Range(a LastRow) = LastRow - 3 .Range(b LastRow).Resize(, 3) = Split(Me.TextBox2.Value , Me.TextBox1.Value , Me.TextBox3.Value, ,) End With wbkOpen.Close 1 Set wbkOpen = Nothing MsgBox Done, , ExcelFox.com Unload Me Else MsgBox Workbook ' FileName ' is already opened. vbLf Close the workbook and try again, vbInformation, ExcelFox.com Exit Sub End If Else MsgBox Emp ID is missing, vbInformation, ExcelFox.com Me.TextBox3.SetFocus End If Else MsgBox Batch No is missing, vbInformation, ExcelFox.com Me.TextBox2.SetFocus End If Else MsgBox Site is missing, vbInformation, ExcelFox.com Me.TextBox1.SetFocus End If End Sub Private Sub CommandButton2_Click() Unload Me End Sub Function FileIsOpen(ByVal FileName As String) As Boolean Dim ff As Long On Error GoTo Xit ff = FreeFile() Open FileName For Random Access Read Write Lock Read Write As ff Close ff FileIsOpen = False Exit Function Xit: Close ff FileIsOpen = True End Function In I1 enter the network path. Kris ExcelFox -- 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
$$Excel-Macros$$ Broadcasting messages through Excel...
Hi All, This is just my curiosity; can we broadcast any message through a shared excel file to the other user at the same time, when they are using that file….. J Is it possible through VBA??? Thanks Regards, Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- 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$$ Broadcasting messages through Excel...
Ok, I think you know how Windows Broadcating messages works in LAN through Telnet . :) Suppose 10 users is working in a shared excel file in a LAN environment, in 10 different workstations. Now 1 user wants to broadcast a Message through MSGBOX, so that other 9 users can see that Message, including him, is it possible through VBA or any other Excel option? This is just my curiosity...don't take it otherwise. :) -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Tue, Sep 25, 2012 at 8:39 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Can you explain what you actually want to do?* * * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 25 September 2012 8:31 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Broadcasting messages through Excel... ** ** Hi All, This is just my curiosity; can we broadcast any message through a shared excel file to the other user at the same time, when they are using that file….. J ** ** Is it possible through VBA??? ** ** ** ** Thanks Regards, Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- 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
Re: $$Excel-Macros$$ Broadcasting messages through Excel...
Thanks Rajan. :) On Tue, Sep 25, 2012 at 9:10 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *And answer is No **L*** * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 25 September 2012 8:48 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Broadcasting messages through Excel... ** ** Ok, I think you know how Windows Broadcating messages works in LAN through Telnet . :) ** ** Suppose 10 users is working in a shared excel file in a LAN environment, in 10 different workstations. Now 1 user wants to broadcast a Message through MSGBOX, so that other 9 users can see that Message, including him, is it possible through VBA or any other Excel option? ** ** This is just my curiosity...don't take it otherwise. :) ** ** -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. ** ** ** ** On Tue, Sep 25, 2012 at 8:39 PM, Rajan_Verma rajanverma1...@gmail.com wrote: *Can you explain what you actually want to do?* * * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 25 September 2012 8:31 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Broadcasting messages through Excel... Hi All, This is just my curiosity; can we broadcast any message through a shared excel file to the other user at the same time, when they are using that file….. J Is it possible through VBA??? Thanks Regards, Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- 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
Re: $$Excel-Macros$$ Broadcasting messages through Excel...
*Thanks David, this is a very good input...hope you or someone else will try it and share the example with the Group.* * * *Thanks Regards,* *Indrajit* * * On Wed, Sep 26, 2012 at 3:44 AM, David Grugeon da...@grugeon.com.au wrote: On the other hand, it could be yes. If you set up a process where the workbook checked the content of a particular cell at regular intervals, (I don't think the change event would fire for a change made by another user) then any user could put a message in that cell and the procedure could show it as a Msgbox. It would not happen until a refresh occurred, either automatically, on demand, or by opening or closing the file. Haven't tried it, No time just now, but it would be interesting to hear if it does work. Now you know why I very rarely say something can't be done. I may not know how to do it but someone else may. That's the beauty of a group like this. Regards David Grugeon On 26 September 2012 01:40, Rajan_Verma rajanverma1...@gmail.com wrote: And answer is No L Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: 25 September 2012 8:48 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Broadcasting messages through Excel... Ok, I think you know how Windows Broadcating messages works in LAN through Telnet . :) Suppose 10 users is working in a shared excel file in a LAN environment, in 10 different workstations. Now 1 user wants to broadcast a Message through MSGBOX, so that other 9 users can see that Message, including him, is it possible through VBA or any other Excel option? This is just my curiosity...don't take it otherwise. :) -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Tue, Sep 25, 2012 at 8:39 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Can you explain what you actually want to do? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: 25 September 2012 8:31 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Broadcasting messages through Excel... Hi All, This is just my curiosity; can we broadcast any message through a shared excel file to the other user at the same time, when they are using that file….. J Is it possible through VBA??? Thanks Regards, Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- 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
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
*@Group, @ Rajan, @ Don - any solution?* Thanks Regards, Indrajit On Sun, Sep 23, 2012 at 12:04 AM, Indrajit $nai talk2indra...@gmail.comwrote: *@ Rajan, *Yes there are 200 files with the same format. I can do the consolidation part through VBA, it's not a problem. It will be like; there should be a button in the master file, whenever I click on the button a Work allocation form will appear, where I'll put Batch Id (unique no), Site name, and the Emp id, then that particular Batch will assign to that emp. when he/she will finish that work, he/she will click on submit button from the slave file and it will reflect to my master file too. *@ Don,* thanks for your attention. We have almost 200 emp. in our Com., works at the same time. Now I want to allocate work from a single master file to them. If it's possible through any other idea, then please share with me. Thanks Regards, Indrajit On Sat, Sep 22, 2012 at 8:45 PM, dguillett1 dguille...@gmail.com wrote: And my question is why have 200 files. Provide a sample master file and a sample slave file. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Indrajit $nai talk2indra...@gmail.com *Sent:* Saturday, September 22, 2012 9:03 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file. @ Thanks Rajan for your attention. Rajan, I'm totally puzzle ri8 now, how to create this. At present I have created 200 (as per emp. id) different excel file which is linked up with this master file. But sometimes it gets hang during updation, that's why I wanna create this file through VBA, and I'm not so good in VBA. Kindly help me to create this Work allocation file. Thanks Regards, Indrajit On Sat, Sep 22, 2012 at 7:16 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *How you want to Update this file?* ** ** *Regards* *Rajan verma* *+91 7838100659 %2B91%207838100659 [IM-Gtalk]* ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 22 September 2012 7:13 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Required help in Work Allocation VBA based excel file. Hi All, I wanna a create Work Allocation VBA based excel file, here-under is my requirement. 1. There should a single Work allocation file through which I can allocate almost 200 people to there respective work. 2. After completing everyone update there respective file, and the main file gets update automatically. If it is possible then please provide me the code. Kindly find attached the Work allocation file for your reference. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- 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
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
Thanks *Krishna*, thanks a lot. :) it's a gr8 solution. :) -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Sun, Sep 23, 2012 at 3:05 PM, Krishna Kumar krishnak...@gmail.comwrote: Hi Here is a draft version. Work on this and do necessary changes. On Sun, Sep 23, 2012 at 1:27 PM, Indrajit $nai talk2indra...@gmail.com wrote: @Group, @ Rajan, @ Don - any solution? Thanks Regards, Indrajit On Sun, Sep 23, 2012 at 12:04 AM, Indrajit $nai talk2indra...@gmail.com wrote: @ Rajan, Yes there are 200 files with the same format. I can do the consolidation part through VBA, it's not a problem. It will be like; there should be a button in the master file, whenever I click on the button a Work allocation form will appear, where I'll put Batch Id (unique no), Site name, and the Emp id, then that particular Batch will assign to that emp. when he/she will finish that work, he/she will click on submit button from the slave file and it will reflect to my master file too. @ Don, thanks for your attention. We have almost 200 emp. in our Com., works at the same time. Now I want to allocate work from a single master file to them. If it's possible through any other idea, then please share with me. Thanks Regards, Indrajit On Sat, Sep 22, 2012 at 8:45 PM, dguillett1 dguille...@gmail.com wrote: And my question is why have 200 files. Provide a sample master file and a sample slave file. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Indrajit $nai Sent: Saturday, September 22, 2012 9:03 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file. @ Thanks Rajan for your attention. Rajan, I'm totally puzzle ri8 now, how to create this. At present I have created 200 (as per emp. id) different excel file which is linked up with this master file. But sometimes it gets hang during updation, that's why I wanna create this file through VBA, and I'm not so good in VBA. Kindly help me to create this Work allocation file. Thanks Regards, Indrajit On Sat, Sep 22, 2012 at 7:16 PM, Rajan_Verma rajanverma1...@gmail.com wrote: How you want to Update this file? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: 22 September 2012 7:13 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file. Hi All, I wanna a create Work Allocation VBA based excel file, here-under is my requirement. 1. There should a single Work allocation file through which I can allocate almost 200 people to there respective work. 2. After completing everyone update there respective file, and the main file gets update automatically. If it is possible then please provide me the code. Kindly find attached the Work allocation file for your reference. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- 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
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
*@ Group, *suppose I've 200 files in a particular path, now I want to consolidate all of those files data in the master file, I mean to say; in a master file there is a button which will consolidate all the data from those 200 slave file through a single click. Hope it's possible through VBA, if its possible then please provide me the code. *@ Rajan, *thanks for your suggestion. But we don't have MS-Access in our office, only MS-Excel is available. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Sun, Sep 23, 2012 at 3:22 PM, Indrajit $nai talk2indra...@gmail.comwrote: Thanks *Krishna*, thanks a lot. :) it's a gr8 solution. :) -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Sun, Sep 23, 2012 at 3:05 PM, Krishna Kumar krishnak...@gmail.comwrote: Hi Here is a draft version. Work on this and do necessary changes. On Sun, Sep 23, 2012 at 1:27 PM, Indrajit $nai talk2indra...@gmail.com wrote: @Group, @ Rajan, @ Don - any solution? Thanks Regards, Indrajit On Sun, Sep 23, 2012 at 12:04 AM, Indrajit $nai talk2indra...@gmail.com wrote: @ Rajan, Yes there are 200 files with the same format. I can do the consolidation part through VBA, it's not a problem. It will be like; there should be a button in the master file, whenever I click on the button a Work allocation form will appear, where I'll put Batch Id (unique no), Site name, and the Emp id, then that particular Batch will assign to that emp. when he/she will finish that work, he/she will click on submit button from the slave file and it will reflect to my master file too. @ Don, thanks for your attention. We have almost 200 emp. in our Com., works at the same time. Now I want to allocate work from a single master file to them. If it's possible through any other idea, then please share with me. Thanks Regards, Indrajit On Sat, Sep 22, 2012 at 8:45 PM, dguillett1 dguille...@gmail.com wrote: And my question is why have 200 files. Provide a sample master file and a sample slave file. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Indrajit $nai Sent: Saturday, September 22, 2012 9:03 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file. @ Thanks Rajan for your attention. Rajan, I'm totally puzzle ri8 now, how to create this. At present I have created 200 (as per emp. id) different excel file which is linked up with this master file. But sometimes it gets hang during updation, that's why I wanna create this file through VBA, and I'm not so good in VBA. Kindly help me to create this Work allocation file. Thanks Regards, Indrajit On Sat, Sep 22, 2012 at 7:16 PM, Rajan_Verma rajanverma1...@gmail.com wrote: How you want to Update this file? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: 22 September 2012 7:13 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file. Hi All, I wanna a create Work Allocation VBA based excel file, here-under is my requirement. 1. There should a single Work allocation file through which I can allocate almost 200 people to there respective work. 2. After completing everyone update there respective file, and the main file gets update automatically. If it is possible then please provide me the code. Kindly find attached the Work allocation file for your reference. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- Join official facebook page of this forum @ https://www.facebook.com
Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.
@ Thanks Rajan for your attention. Rajan, I'm totally puzzle ri8 now, how to create this. At present I have created 200 (as per emp. id) different excel file which is linked up with this master file. But sometimes it gets hang during updation, that's why I wanna create this file through VBA, and I'm not so good in VBA. Kindly help me to create this Work allocation file. Thanks Regards, Indrajit On Sat, Sep 22, 2012 at 7:16 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *How you want to Update this file?* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 22 September 2012 7:13 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Required help in Work Allocation VBA based excel file. ** ** Hi All, ** ** I wanna a create Work Allocation VBA based excel file, here-under is my requirement. ** ** 1. There should a single Work allocation file through which I can allocate almost 200 people to there respective work. 2. After completing everyone update there respective file, and the main file gets update automatically. ** ** If it is possible then please provide me the code. Kindly find attached the Work allocation file for your reference. ** ** Thanks in advance. ** ** ** ** -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- 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
Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012
*Congrats Noorain. :)* * * * * On Mon, Sep 3, 2012 at 11:59 AM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Hi Noorain, Great job Dear, Congratulations !!! On Mon, Sep 3, 2012 at 10:40 AM, Seraj Alam seraj.ala...@gmail.comwrote: congrats noorain bhai. On Mon, Sep 3, 2012 at 10:35 AM, अनिल नारायण गवली gawlianil8...@gmail.com wrote: Dear noorian, Congrats Dear..:) Thanks Regards, Gawli Anil On Mon, Sep 3, 2012 at 10:20 AM, Kuldeep Singh naukrikuld...@gmail.comwrote: Congrats Noorain Sir. Regards, Kuldeep Singh Back Office Executive (MIS) Info Edge India Limited (naukri.com) 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.* On Sun, Sep 2, 2012 at 12:55 PM, Mohammed Muneer mmun...@ccc.com.qawrote: Dear Noor, ** ** Congratulations friend, this is a really a landmark on whole excel platform. ** ** U r doing a tremendously great job, by bringing untiring efforts from u r side to help all the group members – when they are at a stage of feeling helpless to solve the problems arising in excel formula, functions and vba. ** ** The problem in excel are mountain in size when coming to solve them by ourselves, but for u the problem is trivial and of mole sized. ** ** I am happy to hear from Mr. Ayush the excel macros group MVP. ** ** Fairly it’s worth sharing this moment with all of us, and getting the greetings from the group members. ** ** At last keep it up! ** ** Regards, Muneer, CC…. ** ** ** ** ** ** ** ** -- 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
$$Excel-Macros$$ How many time I've opened a particular file in a day?
Hi All, Can we track through VBA, how many time I've opened a particular file in a day? If it's possible then please provide me the VBA code. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- 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$$ Noorain Ansari - Most Helpful Member July 2012
Congrats Noorain. :) On Sat, Aug 4, 2012 at 5:20 PM, jmothilal gjmothi...@gmail.com wrote: Thanks with Congrats Noorain. Mothilal.J On Sat, Aug 4, 2012 at 4:16 AM, dguillett1 dguille...@gmail.com wrote: Good work! Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Ayush Jain jainayus...@gmail.com *Sent:* Friday, August 03, 2012 12:40 PM *To:* excel-macros excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012 Dear members, Noorain Ansari has been selected as 'Most Helpful Member' for the month of July'12. He has posted 143 posts in July 2012 and helped many forum members through his excel expertise. I truly appreciate his consistency and commitment to the group. He is really doing great job. Thanks to Don, Deba Ranjan, Magnesh, Ashish, Rajan, bpascal, Prince, Sunita and other folks for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Required some MS Excel question for interview.
Thanks a lot Noorain. :) On Fri, Jul 20, 2012 at 9:52 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Indrajit, PFA On Fri, Jul 20, 2012 at 9:48 AM, Indrajit $nai talk2indra...@gmail.comwrote: Thanks Noorain, but please send me the Answer paper also. :) On Fri, Jul 20, 2012 at 8:07 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Indrajit, See attached sheet, Hope it hlep to you. On Fri, Jul 20, 2012 at 2:04 AM, Indrajit $nai talk2indra...@gmail.comwrote: Hi All, Can some one provide me some set of MS Excel (Practical and Theoretical) question for interview. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelvbaclinic.blogspot.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelvbaclinic.blogspot.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros
Re: $$Excel-Macros$$ How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?
Thanks a lot @ Noorain. :) On Wed, Jul 18, 2012 at 9:32 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: On Wed, Jul 18, 2012 at 3:09 AM, Indrajit $nai talk2indra...@gmail.comwrote: Hi All, Tell me some easiest way to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelvbaclinic.blogspot.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Required some MS Excel question for interview.
Thanks Noorain, but please send me the Answer paper also. :) On Fri, Jul 20, 2012 at 8:07 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Indrajit, See attached sheet, Hope it hlep to you. On Fri, Jul 20, 2012 at 2:04 AM, Indrajit $nai talk2indra...@gmail.comwrote: Hi All, Can some one provide me some set of MS Excel (Practical and Theoretical) question for interview. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelvbaclinic.blogspot.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?
Thanks to everyone.but can you send me some example file with the attachment. On Wed, Jul 18, 2012 at 4:34 PM, pankaj sangotra psangotr...@gmail.comwrote: Go to techonthenet website, it will surely help u out buddy On Jul 18, 2012 3:09 AM, Indrajit $nai talk2indra...@gmail.com wrote: Hi All, Tell me some easiest way to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?
Thanks buddy. On Wed, Jul 18, 2012 at 10:55 PM, Prince Dubey prince141...@gmail.comwrote: Hi Indrajit, I thing this site will help you http://www.ozgrid.com/ regards prince dubey On Wednesday, July 18, 2012 3:09:11 AM UTC+5:30, Bullet wrote: Hi All, Tell me some easiest way to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ How to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions?
Hi All, Tell me some easiest way to learn/understand INDEX, INDIRECT, FIND, MATCH, OFFSET functions. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ MVP Award....Congratulations Ashish Koul and Dilip Pandey !!
*Congrats..Ashish Dilip*. :) On Thu, Jul 5, 2012 at 11:05 AM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: cong both of you Regards, Sanjib On Wed, Jul 4, 2012 at 8:45 PM, Divaker Pandey divake...@gmail.comwrote: *Congrats..Ashish Dilip, for your gr8 Achievement.* But it will be awesome.if you explore with group member, your journey to plan, execution and finally getting award. Hope another group member can get this award. Divaker On Wed, Jul 4, 2012 at 2:02 PM, NRao Mynampati ml.narasimha...@gmail.com wrote: Congaratulation Ashish and Dilip On Tue, Jul 3, 2012 at 12:17 PM, Excel Vba excelvba.lear...@gmail.comwrote: Congrats both of them. God bless.. On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.comwrote: Dear members, I am extremely happy to inform you that two members of the group are awarded Microsoft Most Valuable Professional Award. My heartiest congratulations to *Ashish koul* and *Dilip Pandey* and thanks for their big support to this forum. Keep posting ! Best regards, Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- - -- FORUM RULES (986+ members already BANNED for violation)
Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******
Congrats Asish. :) On Tue, Jul 3, 2012 at 8:27 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Show group already have 03 users received decode of the Microsoft, real absolute. I am tham community this because it very useful to add comments expression cho me also like all all user. Sorry, I was busy at the work group, wish all the members of this forum to achieve important event, I hope that in future other members can achieve as Ashish koul and Pandey Dilip, hope you two continue to contribute to better forum. 2012/7/3 Dilip Pandey dilipan...@gmail.com Congratulations Ayush . . . . !! This is a wonderful group with full of energy and learning. Thanks to all the members for achieving this milestone. :) Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi -62, India On Mar 22, 2012 4:25 AM, Ayush Jain jainayus...@gmail.com wrote: Dear members,** I am proud to announce that the forum has completed 5 years today. This is really great milestone of the forum. My sincere thanks to each one of you who keep this forum alive by asking questions and helping others by providing solutions. Over the last five years, I have seen decent growth in the number of posts and quality of solutions provided by the experts here. I have learned many things from this forum and experts. In my view, Learning never stops and the discussion forum is the best place to learn and share the skills. I hardly get time to resolve the excel queries after office hours but I try my best to moderate the forum closely. I visit the forum 2-3 times daily to approve the messages and to check everything is ok. Please let me know the improvements and changes you want to see in the forum. I would be happy to hear your feedback. Some key achievements of this forum in numbers: 1) In last 1.5 years, we have seen three people receiving the Microsoft MVP award from this forum. This is itself a big achievement for forum and I hope to see more deserving people get this award in future. 2) This is spam free forum and we hardly get spam messages. In last 5 years, 1000 members are banned for sending spam messages 3) We are 8400+ members with diversity in expertise, experience and location. 4) Over 7600+ topics discussed in five years Once again many thanks and congratulations to all of you. Keep posting and together we will achieve more milestones. Regards, Ayush Jain Microsoft MVP Forum Owner jainayus...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion
$$Excel-Macros$$ Need some VBA Question for interview.
Hi All, Can someone provide me some VBA Question for interview. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates
@Noorain, thanks for your help, its working. :D Thanks Regards, Indrajit On Thu, Jun 21, 2012 at 1:16 PM, Maries talk2mar...@gmail.com wrote: Hi, Find the attached file of Construction Projects Dashboard which is designed by me. On Wed, Jun 20, 2012 at 8:22 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Indrajit, First of all this is not my dashboard, it's designed by one of our group member Hilary. Brother..you goto Excel Option-Advance and check Show Sheet Tab Option. After this all hide sheet will show. Hope it will help to you. Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 21, 2012 at 12:44 AM, Indrajit $nai talk2indra...@gmail.comwrote: @Dear Noorain, In one of your Dashboard sample file (DASHBOARD REPORT-BROKERAGE-V2.5) all the sheets are hidden but links are working, can you please explain how to create this kind of file. Thanks in advance. Thanks Regards, Indrajit On Tue, Jun 19, 2012 at 10:15 PM, pankaj gmail account pankaji...@gmail.com wrote: Thanks You both Really they are great. We should share more sample Dashboards in Excel Regards Pankaj Michael On Tue, Jun 19, 2012 at 8:37 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Thanks Noorain for sharing such nice examples..!!! On Tue, Jun 19, 2012 at 6:51 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: PFA On Tue, Jun 19, 2012 at 6:49 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Many many thanks for this On Tue, Jun 19, 2012 at 6:39 PM, CoRe neculae.vale...@gmail.comwrote: Hello Pankaj, As far as i know chandoo has greate dashboard templates for free , Attached you can find out a few chandoo dashboards , maybe they skipped your eyes. On Monday, June 18, 2012 8:31:48 PM UTC+3, panky wrote: Dear All, Please share Dashboard Examples/Templates I already viewed Chandoo's Site so no reference to that site. -- Pankaj Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates
@Dear Noorain, In one of your Dashboard sample file (DASHBOARD REPORT-BROKERAGE-V2.5) all the sheets are hidden but links are working, can you please explain how to create this kind of file. Thanks in advance. Thanks Regards, Indrajit On Tue, Jun 19, 2012 at 10:15 PM, pankaj gmail account pankaji...@gmail.com wrote: Thanks You both Really they are great. We should share more sample Dashboards in Excel Regards Pankaj Michael On Tue, Jun 19, 2012 at 8:37 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Thanks Noorain for sharing such nice examples..!!! On Tue, Jun 19, 2012 at 6:51 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: PFA On Tue, Jun 19, 2012 at 6:49 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Many many thanks for this On Tue, Jun 19, 2012 at 6:39 PM, CoRe neculae.vale...@gmail.comwrote: Hello Pankaj, As far as i know chandoo has greate dashboard templates for free , Attached you can find out a few chandoo dashboards , maybe they skipped your eyes. On Monday, June 18, 2012 8:31:48 PM UTC+3, panky wrote: Dear All, Please share Dashboard Examples/Templates I already viewed Chandoo's Site so no reference to that site. -- Pankaj Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ Need Help
*@ Noorain, thanks dear, thanks a lot. :)* On Mon, Jun 11, 2012 at 2:15 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Indrajit, Please find attached Snapshot. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jun 11, 2012 at 9:40 AM, Indrajit $nai talk2indra...@gmail.comwrote: *@Noorain, is this option available in MS Excel 2007? If yes, then can you please send a snapshot for exact location, because I am not getting this option in my MS Excel 2007.* On Fri, Jun 8, 2012 at 7:24 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mangesh, Goto to Excel Option-Fomula-Uncheck Use GetPivot Data function Then use in B8 *=AVERAGE(B3:B6)* -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 7, 2012 at 11:01 PM, Mangesh Dayne mangesh.da...@gmail.comwrote: Hi Friends, Please find the attached sheet and for this, I need average for the pivot table. Also explain me procedure. Thanks Mangesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners
Re: $$Excel-Macros$$ Need Help
*@Noorain, is this option available in MS Excel 2007? If yes, then can you please send a snapshot for exact location, because I am not getting this option in my MS Excel 2007.* On Fri, Jun 8, 2012 at 7:24 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mangesh, Goto to Excel Option-Fomula-Uncheck Use GetPivot Data function Then use in B8 *=AVERAGE(B3:B6)* -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, Jun 7, 2012 at 11:01 PM, Mangesh Dayne mangesh.da...@gmail.comwrote: Hi Friends, Please find the attached sheet and for this, I need average for the pivot table. Also explain me procedure. Thanks Mangesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)
Congrats Rajan. :D On Mon, Jun 4, 2012 at 6:06 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Thank you all J ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *resp...@gmail.com *Sent:* 04 June 2012 12:18 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)* *** ** ** Congratulation Raj. Proud of you. Lunch for you tommorrow. Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: *Ayush Jain jainayus...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Sun, 3 Jun 2012 23:12:31 +0530 *To: *excel-macrosexcel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12) ** ** Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of May'2012 He has posted 147 posts in May 2012 and helped many people through his expertise. I truly appreciate his consistency and commitment to group. He is really doing great job God bless you :) Thanks to Noorain, Don, Asa, Maries, and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Trust me, It requires big heart to help others voluntarily and thanks to everyone who is supporting this forum. Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
Re: $$Excel-Macros$$ Require Business related PPT presentation template.....
@ASA, thanks a lot. :) On Sun, Jun 3, 2012 at 7:45 AM, Asa Rossoff a...@lovetour.info wrote: Hi Indrajit, You could try searching @ Office.com; for example: http://office.microsoft.com/en-us/templates/results.aspx?qu=businessex=1av=zpp Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Thursday, May 31, 2012 7:08 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Require Business related PPT presentation template. ** ** Hi All, Can anyone share some Business related PPT presentation template!!! Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Require Business related PPT presentation template.....
Hi All, Can anyone share some Business related PPT presentation template!!! Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Require Business related PPT presentation template.....
@Rajan, it's all related to Excel, there is no PPT Template / Presentation available. On Thu, May 31, 2012 at 7:45 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Search on chandoo.org ** ** ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 31 May 2012 7:38 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Require Business related PPT presentation template. ** ** Hi All, Can anyone share some Business related PPT presentation template!!! Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ MACRO
Dear Noorian, Can you please send me those ebooks to my mail id: talk2indra...@gmail.com Thanks in advance. On Thu, May 31, 2012 at 4:44 PM, Prakash Paul jprakashp...@gmail.comwrote: Dear Noorian, Please send the 2007 file to jprakashp...@gmail.com. Thanks in advance Regards Paul -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!
Hi All, Can anyone explain how to use Vlookup, Index, Match, Offset function in VBA Coading -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?
@ Ranjan, no attachment file available.can you please forward it once again. On Mon, May 14, 2012 at 6:18 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Please find the attached Sheet *I have used Validation in that table* ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 14 May 2012 4:17 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? ** ** @Ranjan, I have attached the Numeric Typing Tutor file along with this mail (used your code only). I need a small favor from your end. Suppose someone is typing the same no. which shows in the Sample No. 1 and 2, (its an image), but he types some wrong no. can it possible at that time (wrong type) shows some error message, if its possible then please send me the code. ** ** ** ** ** ** On Sun, May 13, 2012 at 3:19 PM, Indrajit $nai talk2indra...@gmail.com wrote: Thanks a lot Ranjan.really you are Great. :) On Sun, May 13, 2012 at 11:18 AM, Rajan_Verma rajanverma1...@gmail.com wrote: Try this: Public StartTIme Public EndTime Public ResTime As String Sub StartTimer() MsgBox Time Start Now StartTIme = Time End Sub Sub EndTimer() EndTime = Time ResTime = Format(StartTIme - EndTime, hh:mm:ss) MsgBox Total Range(rngFilled).SpecialCells(xlCellTypeConstants).Cells.Count Filled In Minute(ResTime) Minute Second(ResTime) Second Time, vbInformation StartTIme = Empty EndTime = Empty End Sub * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 13 May 2012 1:35 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? @Ranjan, Unprotech sheet password = 007 On Sun, May 13, 2012 at 1:21 AM, Indrajit $nai talk2indra...@gmail.com wrote: @Ranjan, I have attached the file, hope you can understand actually what I am looking for? I have used your code in it but is displaying the count only, means if I filled 24 cells in 3 minutes still it is showing Total cells filled in a minute is 24 can you please check it once, and revert me the same. On Fri, May 11, 2012 at 10:53 PM, Indrajit $nai talk2indra...@gmail.com wrote: Thanks Ranjan. ** ** On Fri, May 11, 2012 at 8:46 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hope it will work for you Public blnFlag As Boolean Sub StartTimer() If blnFlag = True Then MsgBox Total Cells Fillled in a minute is = Sheet1.UsedRange.SpecialCells(xlCellTypeConstants).Count 'Sheet1.UsedRange.ClearContents blnFlag = False End Else MsgBox Time Start blnFlag = True Application.OnTime Now + TimeValue(00:01:00), StartTimer End If End Sub * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 11 May 2012 4:40 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? Yes, Ranjan. On Sun, May 6, 2012 at 7:52 PM, Rajan_Verma rajanverma1...@gmail.com wrote: You mean, You want to know how many cells you can fill in a minute? * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 05 May 2012 03:57 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? Hi All, Can we calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? Can anyone have Typing Practice kind of Macro in Excel, through that we can measure our typing speed? If anyone have this kind of thing then please send me the same. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance
Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!
Thanks for the suggestion.I know the formula, but how can I migrate those formulas with VBA Coding. On Mon, May 14, 2012 at 6:40 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi *You can refer Excel Formula Help to understand how they work **J*** ** ** ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 14 May 2012 3:53 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading ** ** Hi All, ** ** Can anyone explain how to use Vlookup, Index, Match, Offset function in VBA Coading ** ** -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Indrajit Snai +91 9051755745 talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?
@ Ranjan, thanks a lot for all of your effort, but it is not working properly, only 1st cell is working perfectly On Mon, May 14, 2012 at 9:35 PM, Rajan_Verma rajanverma1...@gmail.comwrote: See the attached Sheet ** ** ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 14 May 2012 7:13 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? ** ** @ Ranjan, no attachment file available.can you please forward it once again. On Mon, May 14, 2012 at 6:18 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Please find the attached Sheet *I have used Validation in that table* * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 14 May 2012 4:17 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? @Ranjan, I have attached the Numeric Typing Tutor file along with this mail (used your code only). I need a small favor from your end. Suppose someone is typing the same no. which shows in the Sample No. 1 and 2, (its an image), but he types some wrong no. can it possible at that time (wrong type) shows some error message, if its possible then please send me the code. On Sun, May 13, 2012 at 3:19 PM, Indrajit $nai talk2indra...@gmail.com wrote: Thanks a lot Ranjan.really you are Great. :) ** ** On Sun, May 13, 2012 at 11:18 AM, Rajan_Verma rajanverma1...@gmail.com wrote: Try this: Public StartTIme Public EndTime Public ResTime As String Sub StartTimer() MsgBox Time Start Now StartTIme = Time End Sub Sub EndTimer() EndTime = Time ResTime = Format(StartTIme - EndTime, hh:mm:ss) MsgBox Total Range(rngFilled).SpecialCells(xlCellTypeConstants).Cells.Count Filled In Minute(ResTime) Minute Second(ResTime) Second Time, vbInformation StartTIme = Empty EndTime = Empty End Sub * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 13 May 2012 1:35 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? @Ranjan, Unprotech sheet password = 007 On Sun, May 13, 2012 at 1:21 AM, Indrajit $nai talk2indra...@gmail.com wrote: @Ranjan, I have attached the file, hope you can understand actually what I am looking for? I have used your code in it but is displaying the count only, means if I filled 24 cells in 3 minutes still it is showing Total cells filled in a minute is 24 can you please check it once, and revert me the same. ** ** On Fri, May 11, 2012 at 10:53 PM, Indrajit $nai talk2indra...@gmail.com wrote: Thanks Ranjan. On Fri, May 11, 2012 at 8:46 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hope it will work for you Public blnFlag As Boolean Sub StartTimer() If blnFlag = True Then MsgBox Total Cells Fillled in a minute is = Sheet1.UsedRange.SpecialCells(xlCellTypeConstants).Count 'Sheet1.UsedRange.ClearContents blnFlag = False End Else MsgBox Time Start blnFlag = True Application.OnTime Now + TimeValue(00:01:00), StartTimer End If End Sub * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 11 May 2012 4:40 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? Yes, Ranjan. On Sun, May 6, 2012 at 7:52 PM, Rajan_Verma rajanverma1...@gmail.com wrote: You mean, You want to know how many cells you can fill in a minute? * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 05 May 2012 03:57 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys
Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!
Thanks a lot to all of you. On Mon, May 14, 2012 at 9:44 PM, Rajan_Verma rajanverma1...@gmail.comwrote: ** ** You can put the entire Formula in Evaluate Function of VBA ** ** *Range(A1).Value=Evaluate(=Vlookup(1, D1:D5,2,0))* *Range(A1).Value=Evaluate(=Index(D1:E5,Match(1,D1:D5,0),2))* ** ** ** ** ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 14 May 2012 7:15 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading ** ** Thanks for the suggestion.I know the formula, but how can I migrate those formulas with VBA Coding. On Mon, May 14, 2012 at 6:40 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi *You can refer Excel Formula Help to understand how they work **J* * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 14 May 2012 3:53 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading Hi All, Can anyone explain how to use Vlookup, Index, Match, Offset function in VBA Coading -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Indrajit Snai +91 9051755745 talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?
Thanks a lot Ranjan.really you are Great. :) On Sun, May 13, 2012 at 11:18 AM, Rajan_Verma rajanverma1...@gmail.comwrote: ** ** ** ** Try this: ** ** Public StartTIme Public EndTime Public ResTime As String ** ** Sub StartTimer() MsgBox Time Start Now StartTIme = Time End Sub ** ** Sub EndTimer() EndTime = Time ** ** ResTime = Format(StartTIme - EndTime, hh:mm:ss) MsgBox Total Range(rngFilled).SpecialCells(xlCellTypeConstants).Cells.Count Filled In Minute(ResTime) Minute Second(ResTime) Second Time, vbInformation StartTIme = Empty EndTime = Empty End Sub ** ** ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 13 May 2012 1:35 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? ** ** @Ranjan, Unprotech sheet password = 007 On Sun, May 13, 2012 at 1:21 AM, Indrajit $nai talk2indra...@gmail.com wrote: @Ranjan, I have attached the file, hope you can understand actually what I am looking for? I have used your code in it but is displaying the count only, means if I filled 24 cells in 3 minutes still it is showing Total cells filled in a minute is 24 can you please check it once, and revert me the same. On Fri, May 11, 2012 at 10:53 PM, Indrajit $nai talk2indra...@gmail.com wrote: Thanks Ranjan. On Fri, May 11, 2012 at 8:46 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hope it will work for you Public blnFlag As Boolean Sub StartTimer() If blnFlag = True Then MsgBox Total Cells Fillled in a minute is = Sheet1.UsedRange.SpecialCells(xlCellTypeConstants).Count 'Sheet1.UsedRange.ClearContents blnFlag = False End Else MsgBox Time Start blnFlag = True Application.OnTime Now + TimeValue(00:01:00), StartTimer End If End Sub * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 11 May 2012 4:40 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? Yes, Ranjan. On Sun, May 6, 2012 at 7:52 PM, Rajan_Verma rajanverma1...@gmail.com wrote: You mean, You want to know how many cells you can fill in a minute? * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 05 May 2012 03:57 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? Hi All, Can we calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? Can anyone have Typing Practice kind of Macro in Excel, through that we can measure our typing speed? If anyone have this kind of thing then please send me the same. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem
Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?
Yes, Ranjan. On Sun, May 6, 2012 at 7:52 PM, Rajan_Verma rajanverma1...@gmail.comwrote: You mean, You want to know how many cells you can fill in a minute? ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 05 May 2012 03:57 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? ** ** Hi All, Can we calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? Can anyone have Typing Practice kind of Macro in Excel, through that we can measure our typing speed? If anyone have this kind of thing then please send me the same. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Indrajit Snai +91 9051755745 talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?
Thanks Ranjan. On Fri, May 11, 2012 at 8:46 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hope it will work for you ** ** Public blnFlag As Boolean ** ** Sub StartTimer() ** ** If blnFlag = True Then MsgBox Total Cells Fillled in a minute is = Sheet1.UsedRange.SpecialCells(xlCellTypeConstants).Count 'Sheet1.UsedRange.ClearContents blnFlag = False End Else MsgBox Time Start blnFlag = True Application.OnTime Now + TimeValue(00:01:00), StartTimer End If End Sub ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 11 May 2012 4:40 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? ** ** Yes, Ranjan. On Sun, May 6, 2012 at 7:52 PM, Rajan_Verma rajanverma1...@gmail.com wrote: You mean, You want to know how many cells you can fill in a minute? * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* 05 May 2012 03:57 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? Hi All, Can we calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? Can anyone have Typing Practice kind of Macro in Excel, through that we can measure our typing speed? If anyone have this kind of thing then please send me the same. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Indrajit Snai +91 9051755745 talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive
$$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?
Hi All, Can we calculate WPM (Word Per Minute) in Excel (Only for numeric keys)? Can anyone have Typing Practice kind of Macro in Excel, through that we can measure our typing speed? If anyone have this kind of thing then please send me the same. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******
Congrats Ayush.it's a gr8 achievement. On Sun, Mar 25, 2012 at 4:10 PM, Dilip Pandey dilipan...@gmail.com wrote: Congratulations.. Ayush.. this groups is awesome. Best of luck. Regards, DILIPandey On 3/22/12, Ayush Jain jainayus...@gmail.com wrote: Dear members, I am proud to announce that the forum has completed 5 years today. This is really great milestone of the forum. My sincere thanks to each one of you who keep this forum alive by asking questions and helping others by providing solutions. Over the last five years, I have seen decent growth in the number of posts and quality of solutions provided by the experts here. I have learned many things from this forum and experts. In my view, Learning never stops and the discussion forum is the best place to learn and share the skills. I hardly get time to resolve the excel queries after office hours but I try my best to moderate the forum closely. I visit the forum 2-3 times daily to approve the messages and to check everything is ok. Please let me know the improvements and changes you want to see in the forum. I would be happy to hear your feedback. Some key achievements of this forum in numbers: 1) In last 1.5 years, we have seen three people receiving the Microsoft MVP award from this forum. This is itself a big achievement for forum and I hope to see more deserving people get this award in future. 2) This is spam free forum and we hardly get spam messages. In last 5 years, 1000 members are banned for sending spam messages 3) We are 8400+ members with diversity in expertise, experience and location. 4) Over 7600+ topics discussed in five years Once again many thanks and congratulations to all of you. Keep posting and together we will achieve more milestones. Regards, Ayush Jain Microsoft MVP Forum Owner jainayus...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....
Thanks @ dguillett1. On Thu, Mar 22, 2012 at 6:36 PM, dguillett1 dguille...@gmail.com wrote: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count 1 _ Or Target.Row 2 Then Exit Sub If Target.Column = 1 Or Target.Column = 3 Then If Len(Application.Trim(Target)) 0 Then _ Target.Offset(, 1) = Now End If End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Indrajit $nai talk2indra...@gmail.com *Sent:* Thursday, March 22, 2012 1:23 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro. @ dguillett1, PFA for your reference. On Thu, Mar 22, 2012 at 4:28 AM, dguillett1 dguille...@gmail.com wrote: Without seeing what you want with an example I can’t help Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Indrajit $nai talk2indra...@gmail.com *Sent:* Wednesday, March 21, 2012 5:21 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro. Thanks @ Ranjan, but I don't track it in MS-Access File, can you incorporate this codes for MS-Excel? Thanks @ dguillett1, but I'm not able to use the same code for Logout time tracking in a different column, can you please help me once again? @ Abdulgani Shaikh, I have attached the same file in .xls format. On Wed, Mar 21, 2012 at 11:12 PM, Rajan_Verma rajanverma1...@gmail.comwrote: It’s a old post on this group ,I have created a small tool to track punch in and punch out Time , hope it can help. ‘=** ** Hi Lokesh, I am attaching Two files here.. 1). Save Access file at Shared Location. 2). In Code Module Replace *Thisworkbook.Path* with shared Path 3). Fill *AllEmpID* table in *Database* with EMPID for validation. ObjConnection.ConnectionString = Provider=Microsoft.ACE.OLEDB.12.0;Data Source= *ThisWorkbook.Path* \table.accdb ; ‘=** ** Regards Rajan *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Mar/Wed/2012 03:17 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need a small help, related to the Date and Time macro. Hi All, Need a small help from you all. I have attached a file with this mail. Now if you open the file you can see there is a button named Login, if you click on it, it will take the system time and date. There are two columns available, Name (Column A) and Login Time (Column B), now I want if the respective Column A is blank then it will not put the date and time in Column B, if there is a name in column A then only date and time will be captured in the column B, other wise it will give me a error message. If you have the code for the same then please provide me. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum
$$Excel-Macros$$ Need a small help, related to the Date and Time macro.....
Hi All, Need a small help from you all. I have attached a file with this mail. Now if you open the file you can see there is a button named Login, if you click on it, it will take the system time and date. There are two columns available, Name (Column A) and Login Time (Column B), now I want if the respective Column A is blank then it will not put the date and time in Column B, if there is a name in column A then only date and time will be captured in the column B, other wise it will give me a error message. If you have the code for the same then please provide me. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Login time tracker.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Need a small help
Thanks Don. On Mon, Mar 12, 2012 at 2:38 AM, dguillett1 dguille...@gmail.com wrote: try custom format of h or [$-409]h;@ Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Indrajit $nai talk2indra...@gmail.com *Sent:* Sunday, March 11, 2012 3:52 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need a small help Hi All, Need a small help, can anyone convert the below mention format into the Hour? 3/12/2012 2:21Should be only 2. Is there any formula? if its present then please provide me the same. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Looking for a Macro which can capture the keystroke timing....
Thanks. On Thu, Feb 23, 2012 at 3:22 AM, ChilExcel chilexcel...@gmail.com wrote: check whether this help http://www.rondebruin.nl/key.htm Thanks Chilexcel 2012/2/22, Indrajit $nai talk2indra...@gmail.com: Hi All, Is there any coding is available which can capture the Keystroke in a Excel file, Like whenever I am pressing alt+ctrl+del or locking the system it will automatically capture the timing in a Excel file. If the coding is available then please provide me the same. Thanks in advance for all of your support. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Indrajit Snai +91 9051755745 talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Looking for a Macro which can capture the keystroke timing....
Hi All, Is there any coding is available which can capture the Keystroke in a Excel file, Like whenever I am pressing alt+ctrl+del or locking the system it will automatically capture the timing in a Excel file. If the coding is available then please provide me the same. Thanks in advance for all of your support. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Looking for a Macro which can capture the keystroke timing....
Hi All, Is there any coding is available which can capture the Keystroke in a Excel file, Like whenever I am pressing alt+ctrl+del or locking the system it will automatically capture the timing in a Excel file. If the coding is available then please provide me the same. Thanks in advance for all of your support. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Multiple worksheet in a single file.....need some help
*Thanks Sam, thanks a lot.* * * On Sat, Jan 7, 2012 at 9:14 PM, Sam Mathai Chacko samde...@gmail.comwrote: Back in Delhi Indrajit, the view that you see in that workbook is called the pagelayout (Enum 3) view. This was introduced in Excel 2007, and you can simply go the view tab and click on the pagelayout button. The Normal (Enum 1) and the PageBreak Preview (Enum 2) options were already available in Excel 2003, however, the pagelayout view wasn't. So if you use Excel 2003, you will not find this option. Hope that helps. Regards, Sam Mathai Chacko On Sat, Jan 7, 2012 at 2:38 PM, JAVED KHAN john.he.ma...@gmail.comwrote: it has some kind of excel sheet setting..so go into option On Sat, Jan 7, 2012 at 4:22 AM, Indrajit $nai talk2indra...@gmail.comwrote: Hi All, I got the attached file somewhere from net. Can anyone explain me how to create such kind of workbook like the attached file. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Indrajit Snai +91 9051755745 talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures
$$Excel-Macros$$ Multiple worksheet in a single file.....need some help
Hi All, I got the attached file somewhere from net. Can anyone explain me how to create such kind of workbook like the attached file. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Student_data.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Required help in macro / vba coding........open a file in a particular folder
Thanks.your formula is working. On Wed, Nov 2, 2011 at 4:40 AM, dguillett1 dguille...@gmail.com wrote: If you only have that many why not just do thru a formula where the file does not have to be open. Notice the placement of the ' You could even use indirect to put in the file name, etc ='C:\aa\[3.xls]Sheet24'!A3 ='C:\Users\Administrator\Desktop\05112012\[1.xls]sheet1'!a1 Don Guillett SalesAid Software dguille...@gmail.com *From:* Indrajit $nai talk2indra...@gmail.com *Sent:* Tuesday, November 01, 2011 4:36 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Required help in macro / vba codingopen a file in a particular folder Hi All, I need your help regarding a macro issue. Suppose I have 5 folder in different in my computer desktop and each folder contains a excel file (same name). Now I want a macro which will open each folder and then open the file and will copy the first cell then paste it in my current file cell, like a1 then a2. Now if I change my folder path, it open that folder then the file and contuniue the above mention work. If the particular folder name; which mention in the excel file not found should give a message then again it will continue. My problem is, it's opening the particular folder, if I change the folder name or changing the path in the current excel file it is not working. Is it possible to do this job through a macro! if possible then please send me the code. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Indrajit Snai +91 9051755745 talk2indra...@gmail.com http://globalwarming-globalissue.blogspot.com/http://talk2indrajit.blogspot.com/2010/09/global-warming.html Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss
$$Excel-Macros$$ Required help in macro / vba coding........open a file in a particular folder
Hi All, I need your help regarding a macro issue. Suppose I have 5 folder in different in my computer desktop and each folder contains a excel file (same name). Now I want a macro which will open each folder and then open the file and will copy the first cell then paste it in my current file cell, like a1 then a2. Now if I change my folder path, it open that folder then the file and contuniue the above mention work. If the particular folder name; which mention in the excel file not found should give a message then again it will continue. My problem is, it's opening the particular folder, if I change the folder name or changing the path in the current excel file it is not working. Is it possible to do this job through a macro! if possible then please send me the code. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Current.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Required help in macro / vba coding........open a file in a particular folder
Hi All, I need your help regarding a macro issue. Suppose I have 5 folder in different in my computer desktop and each folder contains a excel file (same name). Now I want a macro which will open each folder and then open the file and will copy the first cell then paste it in my current file cell, like a1 then a2. Now if I change my folder path, it open that folder then the file and contuniue the above mention work. If the particular folder name; which mention in the excel file not found should give a message then again it will continue. My problem is, it's opening the particular folder, if I change the folder name or changing the path in the current excel file it is not working. Is it possible to do this job through a macro! if possible then please send me the code. Thanks in advance. -- Indrajit talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Current.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Want to learn Match and Offset - formulas
Thanks Sir. On Fri, Oct 28, 2011 at 9:08 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Indarjit, Please see attached PFD, Hope it help to u -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Fri, Oct 28, 2011 at 1:15 AM, Indrajit $nai talk2indra...@gmail.comwrote: Hi All, Can anyone tell me the simplified / easiest way to learn Index, Match and Offset - formulas or arrays, with some example. Thanks in advance. -- Indrajit Snai talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Indrajit Snai +91 9051755745 talk2indra...@gmail.com http://globalwarming-globalissue.blogspot.com/http://talk2indrajit.blogspot.com/2010/09/global-warming.html Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Want to learn Match and Offset - formulas
Hi All, Can anyone tell me the simplified / easiest way to learn Index, Match and Offset - formulas or arrays, with some example. Thanks in advance. -- Indrajit Snai talk2indra...@gmail.com Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Need your help in Vlookup formula.....
*Thanks to everyone. But one thing, is it possible to get the correct result with the help of Vlookup formula?* On Fri, Aug 19, 2011 at 8:11 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Thanks and Welcome -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lawali Sent: Friday, August 19, 2011 7:57 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula. Rajan, Your solution is awesome!!! On Aug 19, 9:39 am, Rajan_Verma rajanverma1...@gmail.com wrote: You Can Tri this : Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Err: Dim k As Integer If Target = Range(H7) Then Application.EnableEvents = False Range(F9).Resize(1, Range(F9).End(xlToRight).Row).ClearContents k = 0 For i = 1 To Range(A65536).End(xlUp).Row If Range(A i).Value = Target Then Range(F9).Offset(0, k).Value = Range(A i).Offset(0, 1).Value k = k + 1 End If Next End If Err: Application.EnableEvents = True End Sub From: excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Friday, August 19, 2011 9:20 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula. try this On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai talk2indra...@gmail.com wrote: Hi All, I need your small help in Vlookup formula. I have attached a file with this mail, where you can see 2 columns in the left. One is Qty. another is Sr. no. Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it will show me 14, if I put 600 it will show 6, but the problem is when I am putting 100 or 200 in the input column it is only giving me the Sr. No. 1 (in case of 100) or 2 (in case of 200). But 100 or 200 are available more than one time, so it should give me the result like this; Please enter the Sr. No. --- 100 Qty 1 7 9 How can I do this with the help of Vlookup. Can you help me. Please its urgent. Thanks in advance. -- Indrajit Snai Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- --- - -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/discussexcel -- Regards Ashish Koul http://akoul.blogspot.com/ akoul.blogspot.comhttp://akoul.posterous.com/ http://akoul.wordpress.com/ akoul.wordpress.com My http://in.linkedin.com/pub/ashish-koul/10/400/830 Linkedin Profile P Before printing, think about the environment. -- --- - -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/discussexcel Copy of Vlookup (2).xls 54KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Need your help in Vlookup formula.....
*Thanks to all of you for spending your valuable time*. On Fri, Aug 19, 2011 at 8:11 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Thanks and Welcome -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lawali Sent: Friday, August 19, 2011 7:57 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula. Rajan, Your solution is awesome!!! On Aug 19, 9:39 am, Rajan_Verma rajanverma1...@gmail.com wrote: You Can Tri this : Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo Err: Dim k As Integer If Target = Range(H7) Then Application.EnableEvents = False Range(F9).Resize(1, Range(F9).End(xlToRight).Row).ClearContents k = 0 For i = 1 To Range(A65536).End(xlUp).Row If Range(A i).Value = Target Then Range(F9).Offset(0, k).Value = Range(A i).Offset(0, 1).Value k = k + 1 End If Next End If Err: Application.EnableEvents = True End Sub From: excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Friday, August 19, 2011 9:20 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need your help in Vlookup formula. try this On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai talk2indra...@gmail.com wrote: Hi All, I need your small help in Vlookup formula. I have attached a file with this mail, where you can see 2 columns in the left. One is Qty. another is Sr. no. Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it will show me 14, if I put 600 it will show 6, but the problem is when I am putting 100 or 200 in the input column it is only giving me the Sr. No. 1 (in case of 100) or 2 (in case of 200). But 100 or 200 are available more than one time, so it should give me the result like this; Please enter the Sr. No. --- 100 Qty 1 7 9 How can I do this with the help of Vlookup. Can you help me. Please its urgent. Thanks in advance. -- Indrajit Snai Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- --- - -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/discussexcel -- Regards Ashish Koul http://akoul.blogspot.com/ akoul.blogspot.comhttp://akoul.posterous.com/ http://akoul.wordpress.com/ akoul.wordpress.com My http://in.linkedin.com/pub/ashish-koul/10/400/830 Linkedin Profile P Before printing, think about the environment. -- --- - -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below linkhttp://www.facebook.com/discussexcel Copy of Vlookup (2).xls 54KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us
$$Excel-Macros$$ Need your help in Vlookup formula.....
Hi All, I need your small help in Vlookup formula. I have attached a file with this mail, where you can see 2 columns in the left. One is Qty. another is Sr. no. Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it will show me 14, if I put 600 it will show 6, but the problem is when I am putting 100 or 200 in the input column it is only giving me the Sr. No. 1 (in case of 100) or 2 (in case of 200). But 100 or 200 are available more than one time, so it should give me the result like this; *Please enter the Sr. No. *--- 100 *Qty * 1 7 9 How can I do this with the help of Vlookup. Can you help me. Please its urgent. Thanks in advance. -- Indrajit Snai Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Vlookup.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Requesting for a small help in vba coding....
Thanks Ranjan, thanks a lot. On Tue, May 31, 2011 at 10:11 AM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi, Paste this Code For Save Button. Private Sub CommandButton1_Click() On Error Resume Next Dim wb As Workbook Dim acwb As Workbook Set acwb = ActiveWorkbook Set wb = Workbooks(Book2) If wb Is Nothing Then Set wb = Workbooks.Open(Filename:=D:\Book2.xls) End If acwb.Sheets(1).Range(C1:D1).Copy wb.Sheets(Sheet1).Range(A30).End(xlUp).Offset(1, 0) wb.Activate Application.CutCopyMode = False acwb.Activate End Sub *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai *Sent:* Monday, May 30, 2011 3:12 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Requesting for a small help in vba coding Hi All, I need a small help in vba coding, I have attached two files; in save.xls it has a command button named save, when I press this button it will copy data from d1:d1 and paste in the file Book2.xls in the range a1:b1 then a2:b2 onward. But somehow this macro is not working properly. It is working when I am saving the data in the same excel file i.e. save.xls, but it is not saving the data in the different excel file i.e. Book2.xls. Please vba gurus I need your help to solve this problem. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ A small query, need your help in vba coding.
Hi All, I have a little query in vba coding, please see the attached file. In the excel file there is a Save command button, whenever I press the button it will copy the data from cell no. c1:d1 and paste in the cell a1:b1, now my query is, if the data is already in the cell no. a1:b1 it will be saved in the next cell no. means a2:b2 then a3:b3 just going on like this, can anyone help me in that coding how do I create that loop? Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel save.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ discussexcel.com Launched today
Congrats Dear.. On Sun, Mar 20, 2011 at 10:18 PM, Dhananjay Pinjan dppin...@gmail.comwrote: Thousand time Congratulation dear Ayush. This forum will definately played a very vital role for whom those are very eager to know the Excel. Thanks for your always support to the members of our various Excel Group. Regards, Dhananjay On Sun, Mar 20, 2011 at 9:21 PM, Ayush Jain jainayus...@gmail.com wrote: Dear Excel Group Members, I am very glad to share that* discussexcel.comhttp://www.discussexcel.com/ *website is launched today. The website development was initiated three months back and here is what I achieved. As promised with you, The site is launched on on the *4th Anniversary* of the group. [image: discussexcel_Logo.jpg] http://www.discussexcel.com/ The website is launched with some cool sections like *Excel Interview QA* and *Excel Blog of the month*. I am also planning to add a new section *Excel Expert Interview* soon. I hope you like them. I have selected the simplest tagline *Excel Simplified* as suggested by Balbir Kumar. The website content development is still in progress, I will keep sharing Excel tips and tricks through this portal over the time. Feel free to submit any content you want to be appear on website. *I really want to see this website as largest Excel Knowledge base.* * Finally , Thanks to all excel enthusiasts for keeping me motivated all the time. This is my personal achievement and I duly appreciate your support for the same.* Please go through this portal and provide your valuable feedback/suggestions/comments/inputs on the form located at 'Contact ushttp://www.discussexcel.com/contact-me' Page. Best regards, Ayush Jain Excel Group Owner Manager Microsoft Excel MVP -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Indrajit Snai +91 9051755745 talk2indra...@gmail.com http://globalwarming-globalissue.blogspot.com/http://talk2indrajit.blogspot.com/2010/09/global-warming.html Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel discussexcel_Logo.jpg