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 ...
You don't really need VBA for that - you can use formulas. For example in B2 (the indicated cell):
=COUNTIFS(Database!$D$2:$D$1000, ">5years", Database!$E$2:$E$1000, "Male", Database!$F$2:$F$1000, "GPOC", Database!$I$2:$I$1000, "New Visit", Database!$J$2:$J$1000, $A2)
Similar formulas in C2, D2 etc.
Then fill down.
In the Total row:
=COUNTIFS(Database!$D$2:$D$1000, ">5years", Database!$E$2:$E$1000, "Male", Database!$F$2:$F$1000, "GPOC", Database!$I$2:$I$1000, "New Visit")
what if i switch to access, will it be easier?