Not sure if this is the right place to post this, I really don't know much in excel as far as functions and all that goes. Our office doubled in size and we need to track sheets on one page within the same worksheet.
What I need to do/Can't figure out,(yes I've already tried google x 10)
Count the number of times an entry shows up, by month on each sheet and then have that total display on the totals sheet.
If excel can display the total for the current month on the totals sheet, have about 30 different sheets that need this displayed on the totals sheet.
If excel can update the totals sheet with the most current entry in a sheet, on the totals sheet?
For reference...
Totals sheet reads...
Person's Name | Most Recent Referral | Most Recent Referral File # | MTD Referrals | YTD Referrals
Then there is a sheet for each agent that reads...
Referral Date | Referee Name | Referral File # | Assigned Person | Referral Status
Hope this makes sense, I need this asap and google is just taking too long and I don't really know the right terminology so I'm feeling a little lost. I do have an excel book but thats at home
Thanks
Bookmarks