Forum Discussion
Excel VBA
good morning guys , my name is Logan. I am new to this community and also new to the whole excel VBA thing. I need your help in a project I am working on which is basically spreadsheet with 2 tabs ...
Like HansVogelaar, I would observe that this is a completely standard Excel problem, one might say what spreadsheets were designed for.
= COUNTIFS(
Database[Date], ">=" & startDate,
Database[Date], "<=" & endDate,
Database[Diagnosis], reportDiagnosis,
Database[Designation], reportDesignation,
Database[Age Group], "=" & reportAgeGroup,
Database[Gender], reportGender,
Database[Type of Visit], reportVisitType
)This could be set to update with F9 or be completely automatic. Of course, if you have reason for preferring VBA, that is entirely your choice