I have one ticket template sheet created. One sheet/tab in one workbook. I dont want to have to copy and paste a new sheet/tab everyday I go into Excel to do up a work ticket. So, I am looking to have Excel auto-create sheets in a sequential number series (our purpose is ticket numbers) made from the layout of our template Meaning, each sheet tab will have a new number....61251, 61252, 61253, etc. but have the exact same layout. I can use an exact range if necessary....ie ticket books have 50 tickets per book - 61251-61300 I have been watching some videos but I do not have the F11 function that a lot of them utilize. The Excel version that I have is from Microsoft Home and Office 2016. Any help would be great....thank you
8 freelancers are bidding on average $46 for this job
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
Hi there , i've read your project description about Excel automated create sheets with sequental number and i'm ready to start with the project Sincerely, Avin H.