Hello,

Just joined and am looking to expand my macro ability beyond simple macro recording. I am hoping I could get some guidance on how to complete this task. I have attached my WIP and would appreciate any pointers to help me complete this. I'm finding this to be a very enjoyable challenge but lack enough background to execute my thoughts into code.

1. Program looks for posting day in HB.Input sheet and stores for later reference
2. Looks for location and uses unique last 5 digit number for location
3. Takes Charges/Payments/adjustments from HB.Input sheet and, based on last five numbers of location for case statement, copies the charges/payments/adjustments into the respective sheet in the column with the same posting date.
4. Goes to next location line and repeats until out of location entries in Input file.

Example: after storing posting date of 8/12/2013. Goes to location 'dog - 10113'. Last 5 of location is 10113 and matches that to a case statement. That case statement says for 10113, go to sheet 'Dog', find posting date column "O" and copy charges/payments/adjustments into target cells O6/O7/O8 in "Dog" sheet, respectively. Loops to next line in the location and checks last 5 against case statements....

i've attached what I have now for code structure, but obviously could use tips in logic process, code structure, etc.

AUG Test.xlsm