Hi Guys, Please see attached.
I have a scored record which I wish to make as simple for the user as possible. It is in its basic stages at the moment and have already hit a hitch.
Please note I wish the 'Shots' sheet to be the only place for the user to interact with.
With this in mind it is not uncommon for players to not turn up at all and therefore their score would be a 0 for all attempts and shots.
The 'Totals' sheet only uses data from the whole attempt and not individual shots, if the total figure for all attempts of a single player is 0; I would need this to hide the column, which would automatically remove that person from the chart. Omitting any ugly gaps automatically.
This would mean that the user only needs to be considered with score keeping and not editting the worksheet.
Please note that a player can use as many or as little attempts as possible. The lower the average score the better. Therefore if they score low on their first attempt they may not wish to have any more attempts. Therefore I only want to hide the column if no scores are recorded for all 3 attempts.
Also the scoresheet will be blank before any games begin. Therefore I would like it to unhide the column upon the entry of data.
The macro should also run in realtime as data is entered the "Totals" sheet updates.
Please help, I have attached the spreadsheet and I have recognised the need for a macro but know absolutley nothing about how to make one.
Bookmarks