Tom,

Thank you tremendously! Everything worked great on the test
spreadsheet. I have one issue when I have converted it to the actual
spreadsheet.

Application.Substitute("=Sum(E4:G4)", 4, rng4.Row)

This line seems to be static however, rng4.Row is dynamic. How can I
modify the sum(E4:G4) to mirror the Find in rng4? As an example, if the
Find function returns row 62, it would update the cell row in the sum
accordingly (E62:G62)?

Again, thank you!

Rusty