+ Reply to Thread
Results 1 to 2 of 2

Wrong value to run the macro

  1. #1
    Registered User
    Join Date
    01-31-2015
    Location
    Chennai, India
    MS-Off Ver
    windows7
    Posts
    31

    Wrong value to run the macro

    HI

    Herewith attached my .xlsm am not get the correct answer to run the macro. In column F total count is 729 but in column I total count value is 941. Can any one give the correct solution.

    regards
    Dilipkumar.V
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,083

    Re: Wrong value to run the macro

    I don't really know what your macro is supposed to do. I have just used an Advanced Filter to get a list of the Branches and a simple COUNTIF to count the documents for each Branch; then sorted the list alphabetically.

    You need to clean up the workbook. Remove all the empty rows and all the formatting on each sheet. That will take it down from 5.8Mb to around 197kb

    See attachment

    Regards, TMS
    Attached Files Attached Files
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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] What is wrong with this Macro???!!!!?!?!?!><
    By AstToTheRegionalMGR in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-17-2015, 02:59 PM
  2. [SOLVED] What's wrong with this recorded macro please ?
    By twaccess in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-12-2015, 03:45 PM
  3. HELP: What is wrong with this macro??
    By henwood in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2012, 08:20 AM
  4. What's wrong with this macro?
    By belly0fdesire in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-26-2006, 07:00 PM
  5. What have I done wrong with this Macro???
    By Shandy720 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2005, 12:05 PM

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