+ Reply to Thread
Results 1 to 4 of 4

help on macro to count single so and call type also

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    help on macro to count single so and call type also

    i have set of date in A:A,B:B,C:C at last F:F column contains fill serial no{1,2,3,4.....}
    CRM DATE In A:A column
    SO In B:B column
    CALL TYPE In C:C column

    i have set of macro to count how many times its so gets repeats in column with LABOR ONLY & LABOR & PART in call type column C:C
    but now i calculates both LABOR ONLY & LABOR & PART which are available against so' other wise it gets error

    for e.g for if so DE3233334 only one time and call type LABOR ONLY i want result = "0"
    if so WEE412122 repeats four time but call type LABOR & PART repeats four time i want result as per date sort from min to max 0,1,2,3.

    please find the code

    Please Login or Register  to view this content.
    here getting error like this msg(runtime error 1004 no cells were found
    stops at "
    Please Login or Register  to view this content.
    "

    find the attachment!!!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: help on macro to count single so and call type also

    Urgently requirement any experts can help on this?
    Last edited by breadwinner; 09-11-2013 at 02:04 AM. Reason: expects

  3. #3
    Valued Forum Contributor
    Join Date
    06-17-2009
    Location
    Chennai,India
    MS-Off Ver
    Excel 2003,excel 2007
    Posts
    678

    Re: help on macro to count single so and call type also

    Macro modified see attached file
    breadwinner.....130912"

    confirm to newsgsroup whether it is ok
    Attached Files Attached Files
    I am not an expert. better solutions may be available
    [email protected]

  4. #4
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: help on macro to count single so and call type also

    Nice Venkat!!! You code works perfectly!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to write to multiple cells from a single function call
    By geophysicist in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-14-2013, 11:34 AM
  2. Repeat call count for call center
    By arifmasum in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-08-2013, 10:03 PM
  3. Replies: 0
    Last Post: 03-28-2013, 02:41 AM
  4. Method to call out a table from a single cell
    By erickpay in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-05-2012, 02:04 PM
  5. How to set call count according to call date and time
    By naveen4pundir in forum Access Tables & Databases
    Replies: 0
    Last Post: 04-27-2012, 02:13 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1