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
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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks