Making Workbook for Disc Golf Bag Tag Events - Need Help With Macro To Auto Sort Divisions

Hello,

I am new to using Excel, which in our day and age is starting to be a rarity.

I would say that I have given myself a pretty good crash course in Excel over this past month, but I am at my wits end and would love any assistance anyone can give me.

I play Disc Golf (click here for an introduction to the sport) and am a member of my local Disc Golf club. We just founded this year and we are running Bag Tag challenges where essentially you are ranked in the club based on your performance at each challenge. Tags are currently numbered 1 through 113.

I currently have created a workbook that contains several sheets (***see attached***).

The first sheet is named Player Registration and contains a list of all currently club members. On this page the players will be "checked-in" to the event, with their current tag number, the cost of their entry fee, and any other additional fees marked. If the player is not there, the Tag Number column will be left blank, as well as the Division, Entry Fee, Ace Pool and CTP columns.

The second sheet is named Player Data and contains a copy of all the data on the Player Registration sheet, but is sorted to remove any players who have not shown up for the event. I was using an IF Statement to filter data over to this sheet by whether or not a number was listed in the Tag Number column (D2). This sheet may not be needed if the main macro I am trying to make can be tweaked to filter out any rows that do not contain a bag tag number.

I then have 5 sheets that are named based upon division names (Intermediate, Advanced, Pro, Master, and Women). These are the sheets that I am trying to get the macro I am working on to filter the data to so that I can simply click a tab and see who is in that particular division and any data I need for payouts. Now that I am typing this, it would be nice to have two sheets (Ace Pool and CTP) that get filtered to using this macro as well.

Here is the current Macro that I am trying to use:

Please Login or Register  to view this content.

There are a few issues that I am running in to with this Macro, and I am sure that its something simple since I am very new to using Excel, and just lack the head knowledge to catch the problem and correct it.
1) When i originally had the macro targeting the Player Registration sheet, it would just stop at the first blank entry in the Tag Number column. This lead me creating the Player Data sheet so that I could sort the data and get all non-blank fields grouped together.
2) The macro "appears" to run through the data listed on the Player Data sheet. However, when I look at the sheets that the data should be copying over to, I am missing most of the players, and sometimes i get duplicate entries, or entries on a sheet that should not be located on that particular sheet. I will also occasionally get the header information copying over to a sheet as if it was a valid player.

Is there a way to make this macro (or a better coded one if someone has better) that will export the information on the Player Registration sheet to the correct Division Sheets and ignore any rows that do not contain a Tag Number?

Thanks for you assistance with this issue,

LBS

Hi LBS
Try this code in the attached...let me know of issues.

Please Login or Register  to view this content.