How to Correct This Formula from Converting When Pasted Used VBA

[CHRISOK]

I'm trying to: (1) select a cell, (2) paste in a formula, (3) copy down the formula without it converting itself into something unusable.
I've seen this happen once before but forgot why it occurs and what to do to prevent it from happening again.

Here's the function within my small test file:
=SUMIF(INVENTORY!$C$2:$C$5,PARTS!B2,INVENTORY!$A$2:$A$5)

It converts itself to:
=SUMIF(INVENTORY!$C$2:$C$5,PARTS!XFD2,INVENTORY!$A$2:$A$5)


Here's the code I'm trying to utilize, where the formula gets trashed out - but if anyone has better ideas - I'm open to suggestions!

Please Login or Register  to view this content.

[Norie]

Does this work?

Please Login or Register  to view this content.

[CHRISOK]

WOW - That works beautifully Norie! Thanks so much!
Still learning!