Hi,
I copied G21 to G41 and got:
G21: 06/003
G41: 06/003
G61: 06/003
I copied O1 to O21 etc and got:
O21: 06/002
O41: 06/002
O61: 06/002
and so had to alter the + no. afterwards.
I have double checked your instructions and redid it all again but still got
the same answer. Excel does not seem to be recognising that it has to move
the numbers on.
What am I doing wrong?
Sue

"JE McGimpsey" wrote:

Did you try?

If you copy G21 to G41, you will see

G21: 06/003
G41: 06/005

so you don't have to change the "+ no." XL will automatically adjust the
cell reference.

In article ,
Sue wrote:

Thanks for the prompt response. I have given it a try and it does work but
I still have to change the + no. to get it to move on a number each time. I
have to set up 150 receipts so that way would take alot of time. If you have
another idea I'm all ears.