Excel question

I am trying to make a job ticket in Excel I have it laid out but I need to set up a macro that alwos me to have a job tcket number in one field change by 1 number every time I activate the macro.

for Ex: I have a field set as job ticket number it starts at 100 then when I go to make a new job I press the "ctrl+j" for job ticket nad the number changes to 101.

Is this possible and how would i go about setting it up Any help would be appreciated.

Thanks




Answer this question

Excel question