Thank you so much snb. This is exactly what I needed. I can't tell you how much I appreciate your help!!!!!! And on a Friday afternoon no less!!

If you happen to see this again, I have a few follow up Q's.

1. Can you recommend some reading material or tutorials that I might use to educate my self on the writing of macros?
2. Can you easily modify this code to exclude rows that result in no value?
3. Can the code be modified to include an if/than type statement such that entries marked "Do Not Re-Accrue" are excluded from the result (thereby eliminating the step I made before posting that dataset, which was to filter on "Accrue/Re-Accrue" and then copy/paste values into another sheet?

Again, thank you so much. You just made my life a little easier (and month end close!!).