Find part and add values

Hi hutch,

Just to make you aware, I spotted a small error in the code above and have made an amendment.

The 2 lines containing xlDown have been changed to xlUp (highlighted in red).

The original code works ok, but was checking all cells in a column, the new code only checks up to the last row of data, so is more efficient.

Good luck with the next part.

Thanks again, T-J. I had noticed on a larger sample group that the macro was pretty slow. I'll give the revision a try and see if that speeds me up any. (I'm sure it will.)

Thanks again!!