Code for auto-creating sheets in Excel with sequential numbering

$10-100 CAD

Completed

Posted

about 5 years ago

$10-100 CAD

Paid on delivery

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

Project ID: 18601575

About the project

8 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@nvchien94

Hello employer, My name is Chien. I am an excel VBA coder. I read your descroption that u need a macro to create template for you and I think i can do within 1 hour. I will give you a button and you can click to create new file with new number and save the old file. That’s my current idea now. If u want please contact. Thanks

$30 CAD in 1 day

5.0

(22 reviews)

3.8

8 freelancers are bidding on average $46 CAD for this job

@rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

$50 CAD in 10 days

4.9

(68 reviews)

5.8

@sloker18

I am proficient with Microsoft excel and marco/VBA development, I can write the marco to generate new sheet as requested. You’re welcome to checkout my reviews and project completion rate to have some idea about the quality of my previous works, Would be great if you can provide a sample of your workbook for some more context. Kindly get back to me if you wish to proceed, looking forward to chat further and work on your project.

$50 CAD in 1 day

5.0

(63 reviews)

5.3

@WebArtisans

Hello, I have read your project description, I can help you to make a an app for this purpose, It will manage the files for you in sequential manner and also help you to create a template. Please feel free to ask me any question in the chat about the project, I will be happy to answer. Thank you

$61 CAD in 10 days

5.0

(2 reviews)

3.0

@egafiori

Dear Proyect Manager How are you? My name is Esteban, I'm Industrial Engineer and Excel / VBA Expert. I'm new freelance, You can see some of my experiences in my profile. I can solve this problem as well as help you in economic analysis and evaluations, based on regression studies and statistical estimates. I would love to help you in your project and that you can help me earn more points !! Regards

$15 CAD in 2 days

4.9

(9 reviews)

2.9

@HaryCoders

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.

$10 CAD in 10 days

5.0

(2 reviews)

1.2

@web4x4

Hello! Let's work. I have a lot of experience in implementing similar tasks. Please, message me to private chat and we will discuss the details. I am also good in - CSS, HTML, JS(JQuery, Vue), PHP, MySqll, Linux Servers - can understand code of other developers - engineering and implementing algorithms - OS Linux server administration Ready to start the project immediately.

$100 CAD in 1 day