I have a spreadsheet with four worksheets. Each worksheet has three columns - name, date and score.
I want to add a front page that does averages on the four worksheets. It needs to compile a list for each person on each worksheet (not everyone is on every worksheet) and give me an overall average for that person for each worksheet he appears on, as well as an average for the current month.
I have never worked in VBA and have no idea how to go about this.
Thanx in advance.
I want to add a front page that does averages on the four worksheets. It needs to compile a list for each person on each worksheet (not everyone is on every worksheet) and give me an overall average for that person for each worksheet he appears on, as well as an average for the current month.
I have never worked in VBA and have no idea how to go about this.
Thanx in advance.
