upobDaPlaya
asked on
WIthin VBA summing record count in 3 tabs
Within VBA I am trying to determine how to:
Sum Column A record Count in Worksheet A * 2 + Sum Column A record Count in Worksheet B
Compare with the Sum from Column A record Count in Worksheet C
If it differs than MsgBox "There is a record count difference for Todays Volunteer Intakes"
Sum Column A record Count in Worksheet A * 2 + Sum Column A record Count in Worksheet B
Compare with the Sum from Column A record Count in Worksheet C
If it differs than MsgBox "There is a record count difference for Todays Volunteer Intakes"
ASKER
Unfortunately I need VBA as I need to add this check to an existing module.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi
ASKER
Hi..thx all. Hopefully I was fair with the grading,. I know I asked for VBA, but GoFlow made life easy with his formula.
Open in new window
gowflow