Thank you again for helping me. While working with the codes, I have
found two issues:

1. In the first code you posted, if the last number is not 240241, it
will be a text string (for example 'totals'). Therefore, the following
formula seems to give an error: Abs(rngTarget.Offset(1).Value -
rngTarget.Value) 1

2. The code in your last post gives an error, could that be because
there is no initial search for branch?

It's getting there but not quite perfect yet... If you have any
further help for me I would greatly appreciate it!