Avatar of Berry Metzger
Berry Metzger
Flag for United States of America asked on

Macro runs without listing all entries H:H>0

Hello Experts,
CreateSummary does not pick up all entries on each worksheet where column H>0.
For instance, using the date 8/20 in D1, on sheet WB(15) it skips cell H10 (value=6) and cell H30 (value=27) ; on sheet PL(25) it  skips cell H56 (value=6); however, on sheet PR(35) it picks up every entry H:H>0

@sktneer, originator, may have an insight on what may cause the inconsistency of results.
Thanks in advance,
Berry
SummarizeEntriesGreaterThan0ColumnH.xlsm
Microsoft OfficeMicrosoft ApplicationsMicrosoft ExcelSpreadsheetsVB Script

Avatar of undefined
Last Comment
Berry Metzger

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Rgonzo1971

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Berry Metzger

ASKER
That solved what was a perplexing, seemingly random error!
Thanks so much.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23