Golf Shot Spreadsheet

**Devolution1200** · 04-29-2016, 01:55 PM

Hello, I have recently started playing golf after a 20 year break and I wanted a way of recording and displaying my golf shot distances.
I immediately thought of Excel as I can input from my Android device using Google Drive.
What I want to be able to do is have the front sheet showing the average distance per club and have a sheet per visit to the driving range.
I have tried this and it works fine, however the clever bit I need, is for each sheet I add to update the formula on the first sheet to include the new cells.
Is this possible in Excel?

**oeldere** · 04-29-2016, 02:01 PM

Do yourself a big favorite and add all data in 1 worksheet.

you get better help on your question if you add a small excel file without confidential information.

please also add the expected result in your sheet (manualy).

**Devolution1200** · 05-02-2016, 11:34 AM

Thanks for your reply. I have attached the basic file I have made which just takes into account 1 day of shots. As I explained in the first post, I would like to add a sheet for each day I play and add the results to it. The first sheet (Total Average) updates with the averages from all sheets.