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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.