MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


Posted by Qroozn on December 18, 2001 5:27 PM

you can either set up a custom menu bar (which lists the holes), or you can put a number of buttons on the page to perform the macros.. just a couple of ideas

Posted by Qroozn on December 18, 2001 5:27 PM

you can either set up a custom menu bar (which lists the holes), or you can put a number of buttons on the page to perform the macros.. just a couple of ideas

Posted by Niels on December 18, 2001 5:45 PM

Yeah, I've got the custom menu bar sorted... the problem is trying to get the macro to copy a row from another sheet - easy enough for me, but as each course is in its own row I don't know how to tell the marco to copy a row dependent on the varibale of 'course selected'.

Any more ideas??

Posted by Qroozn on December 18, 2001 7:12 PM

ok.
so you have a page with all different course. and you want the macro to go in and look for all the courses called e.g. 215-biology and copy those lines to another page. correct?

Posted by Niels on December 19, 2001 4:15 AM

If you want a quick way of manually checking, use Find & replace, replace it with ZZ099, and then replace it back again. The first time you do it should show you how many replacements were made.