Automatically add entries to a summary sheet.

This is a technique that I have been trying to figure out for a while and would make a lot of my excel projects work better, but I will use one example to explain what I am talking about.

My friend is an avid golfer and regularly golfs both 9 and 18 hole courses. He then goes into an excel spreadsheet and logs in the next available column the date, the course, and his scores for the front and back 9 holes.

He plays at a variety of courses and as you can assume, each one varies with difficulty. He wants a 'summary' page on sheet2 that will have each course on its own column and show the average front 9 score, back 9 score, ect for that course.

This is easly done with AVERAGEIFs on the summary page if you want to take the time to goto the summary page and type the name of the course in the column every time you play a new course that wasn't previously tracked, but being an excel users, logging your game in the log sheet and then updating the summary sheet by hand is tedious.

How do I get the summary page to recognize when a new course is added to the game log sheet and add a new column for it in the summary sheet?

Thank you for any help,
-mike

Hi Mike,

can you post a sample workbook, so that I don't have to guess at how your data is laid out.

Pete