Since D holds the pay scale which is the the rate of pay, what is your
question? Try phrasing the question so it can be answered.

Meadowlark wrote:

I am tired of looking up and typing in each employees pay scale. Their names
are always in A and rate of pay in D. How can I solve this.
Thank you