Below is the section of code I need help with. VBA is summing the correct range however it's entering that data point at an incorrect location. It's running the code for the first instance it finds "Electronics" which is further up the spreadsheet under "Consumer Electronics". Is there a way I can search for only what's in quotes rather than anything that's contained in the quotes? This would be the ideal solution. Another alternative that would be as effective for this case but not neccessarily all cases would be to establish my search range such that it won't include "Consumer Electronics". Example .Range("C100:C10000").Find instead of .Columns("C:C").Find

.Columns("C:C").Find(What:="Electronics").Offset(0, 10).Formula = "=SUM(" & .Range("L" & Electronics & ":L" & Production_Technology_Equipment).Address(False, False) & ")"