I want to generate Reference no automatically while opening the sheet from command buttion.
Let me explain.
I am having command button on Sheet "Inward Master" for opening Sheet "Inward".
In sheet "Inward" cell "D7" Job no is there. Once i opened the sheet the Job no should update automatically next no of previously updated no.
And in sheet "Inward_View" values to be display on userform listbox with filtering by selecting JOB No, Customer Name, or Inward Date.
Can any one please help me how to do this.
I am attaching my file here for your reference