any help please :( On Sat, Jul 30, 2016 at 10:19 PM, Puttu * <puttu...@gmail.com> wrote:
> Some one look and help on this.... please > > On Sat, Jul 30, 2016 at 12:16 PM, Puttu * <puttu...@gmail.com> wrote: > >> Experts... please please help me on my requirements >> >> On Fri, Jul 29, 2016 at 4:13 PM, Puttu * <puttu...@gmail.com> 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, 2014 Dalcin 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 darren paul.msecr...@earthlink.net JOHN >>> SCANLON 112 Burry Ave Havelock 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 darwin paule...@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 >> > > > > -- > Putta > -- 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.