I'm trying to automate the following workflow tracking process:

1. Enter data about cash receipt in the monthly keylog, update as needed until it's complete.

2. Enter the cash receipt number in the CR tracking log in the month where the cash receipt was submitted (not the month in which it was entered)

Basic structure of the program thus far:

1. User enters data about a cash receipt, creating a CashReceipt object.

2. If the CashReceipt doesn't have all the required data, it's entered in the "Pending" worksheet. Eventually I'll implement a way to complete pending items using vba, but for now, the user has to complete them by hand.

3. If the CashReceipt has all the required data, it's entered in the keylog for the month it was keyed and the active sheet switches to the cash receipt log for the month in which it was submitted.

4. What I want to happen is the "useful" part of the CashReceipt number (example: CE13014 --> 014, WY13120 --> 120) to be put in an 8h x 25w chart (i.e. 014 would go in row 1, slot 14; 120 would go in row 6, slot 20) associated with the prefix. There are 16 possible prefixes in any given month.

Anyone have any ideas?

EDIT: I can post the code if required, but it's pretty messy and lacking encapsulation.