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.
|