Good evening. I have been out of VBA for awhile and trying to update a golf league project built several years ago with some previous help from forum members. The project consists of 3 sheets where core data (scores, subs, and points) is maintained and 1 summary sheet. I used VBA code via a user form to capture and manipulate the core data. As the folks who have been maintaining the league are not Excel savvy, the project is completely locked and all input, updates, etc must be performed via the user form. In the past I had to make all updates to changes in players, etc. so have been working on a method to allow league management to update names, move players from the sub list to regular and other basic changes.
The problem occurs when a player and associated data is moved from one sheet to another (Sub to Regular) in population on the Summary which is managed by normal Excel functions and references. The data moves correctly via the code between the core data sheets, but returns a #REF error on the Summary. This occurs with normal cell references and absolute ($) cell references. I do not believe this is a code issue, but am stumped and have included the code to move the data below:
Any advice on how to resolve will be appreciated.
Bookmarks