View Single Post
  #4   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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.