Hi everyone
I have several worksheets that represent yearly results (labelled 1995,
1996 etc...)
I would like a summary sheet that can pick out common competitors from
each sheet and add that years score to a 'rolling' total.
I had thought a Pivot table would do the job, but can't seem to make it
work.
One point to note is that within each sheet, there are an inconsistent
number of events - for example there might be 8 events in '95 and 9 in
'96 etc. Is that a problem for the pivot table?
Thanks for any suggestions
Neil
Bookmarks