Generate an unique ticket number and create a log

Hi Everyone,

I need help once again. I need a macro which can generate an unique ticket number that starts with WF00----(EX: WF00101), in a click of a button. Next is I also need a macro that will the details from the ticket generator worksheet to logsheet worksheet (only details that are available).


I really need help.

See attached file

Agent Compliance Tracker.xlsm

Thanks.

Cittie