Hi All,
New here and new to excel really... I had a question & don't know if it is something easily solved.
Below is a screen grab of a work drawing list with drawing numbers as per below example... D0001, D0002, D0003 etc.
Is there anyway to get the cell below (Next Drawing No.) to automatically update with the next number in the sequence, after D0003 respectively is entered into a cell? Taking into consideration that previous numbers
will be entered frequently with letters a, b, c etc behind them for drawing revisions.
Thank you for any help in advance.
Regards,
Elliot
New here and new to excel really... I had a question & don't know if it is something easily solved.
Below is a screen grab of a work drawing list with drawing numbers as per below example... D0001, D0002, D0003 etc.
Is there anyway to get the cell below (Next Drawing No.) to automatically update with the next number in the sequence, after D0003 respectively is entered into a cell? Taking into consideration that previous numbers
will be entered frequently with letters a, b, c etc behind them for drawing revisions.
Thank you for any help in advance.
Regards,
Elliot