Copying variable rows from a worksheet
Posted by Niels on December 18, 2001 5:17 PM
I'm trying to write a golf scorer as a little project. I have managed to create a worksheet where course data is input and then copied into another worksheet using a macro, so I end up with multiple courses detailed on one worksheet. What I cannot work out is how I can then have a menu type option which allows me to select a particular course and which then copies the hole-by-hole data for the particualr course selected into a new worksheet. I have feeling that I should be able to do this via funtions and without having to resort to Access, pivot tables etc.
Once that is done the maths for calculating the scores, and various comprisons, is straightforward.