Hi Carroll

Reading problem on my side!

I do not understand why it does it on your side. I have set up a sheet with
similar formulae, and copied your code into a macro. It works fine on my
side, and does not skip a number.

"Carroll" wrote:

Kassie,

I do want it to change. But I would have expected =Receipt!B5 to have
become =Receipt!B6 when the formula got copied down, not =Receipt!B7.
My question is, why did it skip a number?

Thanks,

Carroll Rinehart