It's hard to describe what I want, I'm not really familiar with Excel condition terms but it is basically just like this:
Worksheet= Dr. castro patient consultations A B C D E January 1 2014 Lopez Sam Worksheet= Patient Library A B Jan Feb E Lopez Sam =if 'Dr. castro patient consultations'!A1 = January then +1
I know my question isn't very clear, but I really want to do this project to make our clinic's monthly assessment better. pls help me guys. thanks A LOT.