count each number half set 3n

need count each digit

in the set of 6

be show  in MIDWAY columns area

v1.PNG
from this file
29082348.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?
 
Martin LissConnect With a Mentor Older than dirtCommented:
Two problems:
  1. The font in the MIDWAY columns is red. I don't know if you want that.
  2. There are no formulas in column FL
29082356.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
1- don't have to be red
2-let me add the formula
0
 
Martin LissOlder than dirtCommented:
You can change the font color also:)
1
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

do you need to finish it ?
when i make the changes ?
0
 
Martin LissOlder than dirtCommented:
No.
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great Job ! Expert
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
why  guides numbers dissaper ??

after hit the MIDWAY button?? Please

a1.PNG
0
 
Martin LissOlder than dirtCommented:
I'm sorry about that. You have a column (FG) that has zero width that fooled me. In any case in the 'Midway' macro change

Range("FH4:FK" & ActiveSheet.UsedRange.Rows.Count).ClearContents

- to -

Range("FI4:FK" & ActiveSheet.UsedRange.Rows.Count).ClearContents

I've attached a corrected workbook.
29082356a.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great !! Job  

working as needed !!

Best Expert !
0
 
Martin LissOlder than dirtCommented:
BTW you have several columns like that and it would be a big job but they should be removed and all the code adjusted to the fact that they're gone.
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

you rigth   that will make the  workbook more faster an  robust

im again the time
0
 
Martin LissOlder than dirtCommented:
I don't think it will make it any faster, but it would help avoid mistakes like this one.
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
im agree with you Best Expert
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.