Blackie50
07-22-2010, 07:04 AM
Hi
I have contract numbers containing a mix of letters and numbers. They are 7 digits in length.
The last 3 digits are always numbers
e.g. ABCD259 cell A1 (sheet1)
FTGW514
I would like to be able to copy the contract from one sheet/cell to another but add 1 to it
so ABCD260 cell A1 (sheet2)
FTGW515
Can't seem to make it work.
Any help appreciated
thanks
Jon
I have contract numbers containing a mix of letters and numbers. They are 7 digits in length.
The last 3 digits are always numbers
e.g. ABCD259 cell A1 (sheet1)
FTGW514
I would like to be able to copy the contract from one sheet/cell to another but add 1 to it
so ABCD260 cell A1 (sheet2)
FTGW515
Can't seem to make it work.
Any help appreciated
thanks
Jon