I have a group of names (text) in Col G52:G56. Above that in Col G10:G50
these four names appear several times each. In Col H52:H56 I need to enter a
quantity number and have it populate any cell in H10:H50 with the name
adjacent to the qty from G52:G56, i.e., if G52 has the name of Widget and I
enter a new qty in H52, Excel needs to enter that qty in any cell from
H10:H50 and the name of Widget next to it.

There are nine (9) of these across the worksheet in Columns J & K, M & N, P
& Q, S & T, W & X, Z & AA, AC & AD, AF & AG.

I don't know where to start.

Have I confused anyone except myself?

BoB