I suggested the macro because I will use this over and over, daily with new data blown in to make updates from (same fields/columns, just new info in those fields). This does appear to work (YOU"RE AWESOME!), I just worry I'll break the formula when inputting (usually copy/paste) the new data. Thoughts?