Hi
I'm David Miller from Tamilnadu, my company name is Crystal broadband
networks, i need your help in an excel file which can reduce my work if i
can use a macro, i have mentioned below the file which i will download in
excel format from my CRM and it looks below...
CRYSTAL BROADBAND NETWORKS
PO BOX 580 CLAY CITY, KY 40312-0580
1-877-319-0328 WO no. 561655 (D) WORK the ORDER the
DATE: 05/05/14 E SERVIC C ALL TIME:
10:40 AM JON --------------------------------------------------
------------------------------ 3070-0000340 D /? / 1
ROGERS
LINDA LINDA ROGERS GREENBRIAR RD 356
356 GREENBRIAR RD NC 27886-9498
TARBORO TARBORO NC 27886-9498 PH: (252) 823-8755 WK:
(252) 813-5126 --------------------------------------------------
------------------------------ D Reason: SRO
Scheduled 05/05/14 @ Day No Tag: B03450336 Tech: @ 00: 00-00: 00
Coll: $ 0.00 --------------------------------------------------
------------------------------ On 05/05/14 Effective Pro-Rate 26
Days TAXES AND FEES 1
0.00 + BALANCE CURRENT
-38.86 DUE NOW Google
-38.86 --------------------------------------------------
------------------------------ Directions: Notes:
DISCONNECT
ALL GOT ANTENNA --------------------------------------------------
------------------------------ Serial No.s Converter Status
Converter Serial No.s Status 1)
4) 2)
5) 3)
6)
--------------------------------------------------
------------------------------ Comments:
--------------------------------------------------
------------------------------ Subscriber: ---------------------- Amount
Paid: ------- Cash Additional Shipping / Check No. Technician:
---------------------- SS #: # ------ --------------- DL ----
--------------------------------------------------
------------------------------
CRYSTAL BROADBAND NETWORKS PO BOX 580
CLAY CITY, KY 40312-0580 1-877-319-0328 WO
no. 561676 (D) WORK the ORDER the DATE: 05/05/14
E SERVIC C ALL TIME: 01:51 PM JON
--------------------------------------------------
------------------------------ 3065-0135139 D / / 1 ANN
PATTERSON MARY MARY ANN PATTERSON MELISSA DR 243
243 MELISSA DR MOUNT NC 27801
ROCKY ROCKY MOUNT NC 27801 PH: (757) 581-3293 WK: ()
- --------------------------------------------------
------------------------------ D Reason: SRO
Scheduled 05/05/14 @ Day No Tag: Tech: @ 00: 00-00: 00
Coll: $ 0.00 --------------------------------------------------
------------------------------ On 05/05/14 Effective Pro-Rate 26
Days TAXES AND FEES 1
0.00 + BALANCE CURRENT
58.07 DUE NOW Google
58.07 --------------------------------------------------
------------------------------ Directions: Notes:
DISCONNECT
ALL MOVED TO DISH FOR BETTER SERVICE
--------------------------------------------------
------------------------------ Serial No.s Converter Status
Converter Serial No.s Status 1)
4) 2)
5) 3)
6)
--------------------------------------------------
------------------------------ Comments:
--------------------------------------------------
------------------------------ Subscriber: ---------------------- Amount
Paid: ------- Cash Additional Shipping / Check No. Technician:
---------------------- SS #: # ------ --------------- DL ----
--------------------------------------------------
------------------------------
Like wise I will have about 500 customers to be pulled every day and i only
need few details to be sorted as mentioned below.....
Account Number Custome Name Address Phone number 3020-0130481 GERALD FIELDS
DIXON
BRANCH RD 270, WOOTON KY 41776 PH: (606) 279-3267 WK: () -
3070-0000340 LINDA ROGERS 356 GREENBRIAR RD, TARBORO NC 27886-9498 PH:
(252) 823-8755 WK: (252) 813-5126
Could anyone please help me with this, i would really appreciate them for
the same!!
Thank you for your time in advance,
David Mi
On Saturday, November 3, 2012 at 2:34:24 AM UTC-5, Ayush Jain wrote:
>
>
> Dear Members,
>
> If You Keep Below Points In Mind While Asking Your Query, The Chances To
> Get Answered Is Just High:
>
> 1. *Question Is Your Ensure Not Too Vague.* Do Not Assume Anyone Is
> Familiar With Your Problem. While you can upload small attachments,
> describe your problem in the body of the post. We are fortunate to
> have several Excel gurus, but few mind-readers.
> 2. *The Other Hand On, Skip Irrelevant Details.* Be Descriptive And
> Concise. Short, direct, and to-the-point questions with apt thread
> titles are almost always answered promptly.
> 3. *The Scope Reasonably Keep Narrow.* Questions Like, "How Do I Set
> Up An Accounting System In Excel?" It might be a long time waiting.
> 4. *What You've Explain Already Tried.* ("Calculation Is Set To
> Automatic, But Still Formulas Do Not Compute") So Helpers Do Not Waste
> Your
> Time Or Theirs.
> 5. *A WORKBOOK Post.* Nobody Wants To Type Data From A Picture Or
> Paste Text From Your Post Into A Spreadsheet As A Prelude To Helping.
> Attache
> A File To, You Can Email Attachments To Them As Your Group's Email Address
> Excel
> -... @ Googlegroups.com <javascript:> OR Simply "Attach A File" During
> Posting In New Google Groups.
> 6. Your If Question Has Not Been Answered Within A Day, Consider
> Adding Another Post With Any Additional Information You Believe Is
> Relevant.
> 7. {} From Use The Post Menu To *High** Light The sy Ntax*
>
> Many Thanks
>
> Keep Posting,
>
> -Ayush Jain (Group Manager)
>
>
>
>
>
>
>
--
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.
