Re: $$Excel-Macros$$ Excel Delimiter Help form text file excel file
Some one look and help on this please On Sat, Jul 30, 2016 at 12:16 PM, Puttu *wrote: > Experts... please please help me on my requirements > > On Fri, Jul 29, 2016 at 4:13 PM, Puttu * wrote: > >> Hi Experts, >> >> Need a help either in macro or formula anything is still fine. Below >> format I receive a text file, but I need to all the fields to be updated in >> excel. Please advise is there any easy way to do this and let me know if >> you need more info from my end >> >> *Sample Records Input text File in the below format* >> >> May 9, 2014Dalcin J V gel...@alliedinfo.net Sandra Schuler 112 >> Bruce Road 1 Smooth Rock Falls ON >> 5195281464 8908781912 Morning at 'Work .43971 >> TX150472 V488581 0.043 1720 9.55 >> Self Employed 8919454877 >> >> February 1, 2014 morrison darrenpaul.msecr...@earthlink.net JOHN >> SCANLON 112 Burry AveHavelock ON >> 7808882361 6651525797 Afternoon at Home Z678071 >> TX668289v621966 0.055 2200 1.2 >> Self Employed 9808782973 >> >> September 1, 2014 Reid Roland klwatli...@aol.com JOAN B >> ROARK 112 Burry Ave Toronto ON >> 7099447221 6198440169 Anytime >> QA234304MA484290 FF514882 0.055 2200 1.2 >> Self Employed 6243510114 >> >> July 1, 2014 morrison david monalisachic...@hotmail.com JOSEPH >> PARKER 112 Camli P1 Orangeville >> ON 4034603324 6177795117 Anytime Z677848 >> TX667768 V621868 0.067 2680 9.1 >> Self Employed 8807122072 >> >> July 8, 2014 morrison darwinpaule...@jellsouth.net BRIAN >> EARLEY 112 Camli P1 Barrie ON >> 7809393268 8281152822 Afternoon at Home Z677969 >> TX667768v621899 0.04 1600 2.5 >> Self Employed 6729199981 >> >> >> *Output Excel File should be in the below format* >> >> >> >> *SALES DATE* >> >> *CUSTOMER NAME* >> >> *E-MAIL ADDRESS* >> >> *DEALER NAME* >> >> *CUSTOMER ADDRESS* >> >> *CITY* >> >> *STATE* >> >> *CUSTOMER PHONE* >> >> *DEALER PHONE* >> >> *DELIVERY TIME* >> >> *INVOICE NO* >> >> *INSURANCE POLICY NO* >> >> *CHESIS NO* >> >> *BASIC AMOUNT* >> >> *INSURANCE AMOUNT* >> >> *DISCOUNT* >> >> *EMPLOYER* >> >> *CREDIT CARD NO* >> >> 05/09/2014 >> >> Dakin J V >> >> gel...@alliedinfo.net >> >> Sandra Schuler >> >> 112 Bruce Road 1 >> >> Smooth Rock Falls >> >> ON >> >> 5195281464 >> >> 8908781912 >> >> Morning at Work >> >> Z243971 >> >> TX150472 >> >> V488581 >> >> 0.043 >> >> 1720 >> >> 9.55 >> >> Self Employed >> >> 8919454877 >> >> 02/01/2014 >> >> morrison darren >> >> paul.msecr...@eathlink.net >> >> JOHN SCANLON >> >> 112 Burry Ave >> >> Havelock >> >> ON >> >> 7808882361 >> >> 6651525797 >> >> Afternoon at Home >> >> Z678071 >> >> TX668289 >> >> v621966 >> >> 0.055 >> >> 2200 >> >> 1.2 >> >> Self Employed >> >> 9808782973 >> >> 09/01/2014 >> >> Reid Roland >> >> klwatli...@aol.com >> >> JOAN B ROARK >> >> 112 Burry Ave >> >> Toronto >> >> ON >> >> 7099447221 >> >> 6198440169 >> >> Anytime >> >> QA234304 >> >> MA484290 >> >> FF514882 >> >> 0.055 >> >> 2200 >> >> 1.2 >> >> Self Employed >> >> 6243510114 >> >> 07/01/2015 >> >> morrison david >> >> monalisachic...@hotmail.com >> >> JOSEPH PARKER >> >> 112 Camli Pl >> >> Orangeville >> >> ON >> >> 4034603324 >> >> 6177795117 >> >> Anytime >> >> Z677848 >> >> TX667768 >> >> V621868 >> >> 0.067 >> >> 2680 >> >> 9.1 >> >> Self Employed >> >> 8807122072 >> >> 07/08/2014 >> >> morrison darwin >> >> paule...@jellsouth.net >> >> BRIAN EARLEY >> >> 112 Camli Pl >> >> Barrie >> >> ON >> >> 7809393268 >> >> 8281152822 >> >> Afternoon at Home >> >> Z677969 >> >> TX667768 >> >> v621899 >> >> 0.04 >> >> 1600 >> >> 2.5 >> >> Self Employed >> >> 6729199981 >> >> -- >> Putta >> >> -- >> 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
$$Excel-Macros$$ commission calculation
Please see the attachment, in the file there are two sheets, I need to calculate the commission. The question has defined in the file Thanks for advance -- 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. COMMISSION CALCULATION.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Formula for Numbers Custom Format
Dear Experts, I have little knowledge about Numbers Custom Formatting (Manually) to attach Text with Numbers. I have to use these Numbers (with Text) in Chart. In a large Data being updated frequently, manually Numbers Custom Formatting will be quite hard and chance of error are sure. Kindly provide some Formula which will attach Text to Numbers automatically while result remains as Number. Sample file is attached. Thanks a your guidance in advance. Regards, Zafar Iqbal -- 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. Formula for Numbers Custom Format.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ CONDITIONAL FORMAT BASE OF TWO CRITERIA
Under Condition Formatting Tab, I have put 2 conditions. Please see under Conditional Format > Manage Rules Screenshot attached. On Sat, Jul 30, 2016 at 12:55 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Abhishek Jain, > > Many Many thank you for solving the problem. But will great pleasure if > you show me the step > > Regards, > > Sanjib > > On Fri, Jul 29, 2016 at 5:34 PM, Abhishek Jain> wrote: > >> >> >> On Fri, Jul 29, 2016 at 4:13 PM, Sanjib Chatterjee < >> chatterjee.kolk...@gmail.com> wrote: >> >>> >>> Dear All >>> >>> Please see the attachment and solve the problem . >>> >>> Sanjib >>> >>> >>> >>> -- >>> - >>> >>> -- >>> 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. >>> >> >> -- >> 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. >> > > > > -- > - > -- 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.
Re: $$Excel-Macros$$ CONDITIONAL FORMAT BASE OF TWO CRITERIA
Abhishek Jain, Many Many thank you for solving the problem. But will great pleasure if you show me the step Regards, Sanjib On Fri, Jul 29, 2016 at 5:34 PM, Abhishek Jainwrote: > > > On Fri, Jul 29, 2016 at 4:13 PM, Sanjib Chatterjee < > chatterjee.kolk...@gmail.com> wrote: > >> >> Dear All >> >> Please see the attachment and solve the problem . >> >> Sanjib >> >> >> >> -- >> - >> >> -- >> 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. >> > > -- > 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. > -- - -- 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.
Re: $$Excel-Macros$$ Excel Delimiter Help form text file excel file
Experts... please please help me on my requirements On Fri, Jul 29, 2016 at 4:13 PM, Puttu *wrote: > Hi Experts, > > Need a help either in macro or formula anything is still fine. Below > format I receive a text file, but I need to all the fields to be updated in > excel. Please advise is there any easy way to do this and let me know if > you need more info from my end > > *Sample Records Input text File in the below format* > > May 9, 2014Dalcin J V gel...@alliedinfo.net Sandra Schuler 112 > Bruce Road 1 Smooth Rock Falls ON > 5195281464 8908781912 Morning at 'Work .43971 > TX150472 V488581 0.043 1720 9.55 > Self Employed 8919454877 > > February 1, 2014 morrison darrenpaul.msecr...@earthlink.net JOHN > SCANLON 112 Burry AveHavelock ON > 7808882361 6651525797 Afternoon at Home Z678071 > TX668289v621966 0.055 2200 1.2 > Self Employed 9808782973 > > September 1, 2014 Reid Roland klwatli...@aol.com JOAN B > ROARK 112 Burry Ave Toronto ON > 7099447221 6198440169 Anytime > QA234304MA484290 FF514882 0.055 2200 1.2 > Self Employed 6243510114 > > July 1, 2014 morrison david monalisachic...@hotmail.com JOSEPH > PARKER 112 Camli P1 Orangeville > ON 4034603324 6177795117 Anytime Z677848 > TX667768 V621868 0.067 2680 9.1 > Self Employed 8807122072 > > July 8, 2014 morrison darwinpaule...@jellsouth.net BRIAN > EARLEY 112 Camli P1 Barrie ON > 7809393268 8281152822 Afternoon at Home Z677969 > TX667768v621899 0.04 1600 2.5 > Self Employed 6729199981 > > > *Output Excel File should be in the below format* > > > > *SALES DATE* > > *CUSTOMER NAME* > > *E-MAIL ADDRESS* > > *DEALER NAME* > > *CUSTOMER ADDRESS* > > *CITY* > > *STATE* > > *CUSTOMER PHONE* > > *DEALER PHONE* > > *DELIVERY TIME* > > *INVOICE NO* > > *INSURANCE POLICY NO* > > *CHESIS NO* > > *BASIC AMOUNT* > > *INSURANCE AMOUNT* > > *DISCOUNT* > > *EMPLOYER* > > *CREDIT CARD NO* > > 05/09/2014 > > Dakin J V > > gel...@alliedinfo.net > > Sandra Schuler > > 112 Bruce Road 1 > > Smooth Rock Falls > > ON > > 5195281464 > > 8908781912 > > Morning at Work > > Z243971 > > TX150472 > > V488581 > > 0.043 > > 1720 > > 9.55 > > Self Employed > > 8919454877 > > 02/01/2014 > > morrison darren > > paul.msecr...@eathlink.net > > JOHN SCANLON > > 112 Burry Ave > > Havelock > > ON > > 7808882361 > > 6651525797 > > Afternoon at Home > > Z678071 > > TX668289 > > v621966 > > 0.055 > > 2200 > > 1.2 > > Self Employed > > 9808782973 > > 09/01/2014 > > Reid Roland > > klwatli...@aol.com > > JOAN B ROARK > > 112 Burry Ave > > Toronto > > ON > > 7099447221 > > 6198440169 > > Anytime > > QA234304 > > MA484290 > > FF514882 > > 0.055 > > 2200 > > 1.2 > > Self Employed > > 6243510114 > > 07/01/2015 > > morrison david > > monalisachic...@hotmail.com > > JOSEPH PARKER > > 112 Camli Pl > > Orangeville > > ON > > 4034603324 > > 6177795117 > > Anytime > > Z677848 > > TX667768 > > V621868 > > 0.067 > > 2680 > > 9.1 > > Self Employed > > 8807122072 > > 07/08/2014 > > morrison darwin > > paule...@jellsouth.net > > BRIAN EARLEY > > 112 Camli Pl > > Barrie > > ON > > 7809393268 > > 8281152822 > > Afternoon at Home > > Z677969 > > TX667768 > > v621899 > > 0.04 > > 1600 > > 2.5 > > Self Employed > > 6729199981 > > -- > Putta > > -- > 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. > -- Putta -- 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