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.
