Very basic VBA user form, to concatenate and populate cells in excel

Completed Posted 1 year ago Paid on delivery
Completed Paid on delivery

I have to input some data into a spreadsheet, I'd like to create a macro or a user form to make this faster.

I need to have Columns A - D with some data input from a user form and then have it concatenated into Column E.

Column A needs to have a data validation to only allow a single Character like the letter S for instance.

Column B needs to have today's year YY - 22

Column C needs to have today's day in numerical format 0-365

Column D needs a text value of sequential numbers.

But I need the user form to ask,

Column A letter and quantity of Column D

So S ***** (Starting from 001) Quantity 30

And the output into column E should be S22181001

S22181002

Etc.

Excel Visual Basic VB.NET Data Processing C++ Programming

Project ID: #34023107

About the project

14 proposals Remote project Active 1 year ago

Awarded to:

Tanmoy236

"I am an Excel Expert with Professional experience working with Excel VBA Macro Coding, Formula Generation and Automation/scripting. Developing and designing complicated VBA/Macro programs are part and parcel of my da More

£10 GBP in 1 day
(267 Reviews)
7.1
edatawiz

Hi there I can deliver this in a day to you onlg with the wait time and our discussions. I will shortly post a sample for you to review Regards Vishy

£15 GBP in 2 days
(21 Reviews)
4.1

14 freelancers are bidding on average £20 for this job

MamukaB

Hello I can help to you. Can to do within few hours I have 15+ year experience of Excel, Excel VBA So, you can trust to me. Result will be excellent Best Regard

£15 GBP in 1 day
(31 Reviews)
4.4
Ahsan2526

Hi, I will build a macro for this in an hour . Please send me a message so we can discuss further. Thank you

£15 GBP in 1 day
(11 Reviews)
3.4
anenkovakateryna

Hi I've read the project description carefully. I'm an expert in Excel VBA. Hope you contact me to discuss project more detail. Best regards!

£20 GBP in 1 day
(2 Reviews)
3.0
torrikress2

✅✅✅ Experiences in Excel Functions, Macro, Formula ✅✅✅ Hi, Dear! I have a full experiences and knowledge in Excel Functions, Macro, Formula . Hope to discuss with you soon. Thanks & Best regards! [login to view URL] More

£30 GBP in 1 day
(5 Reviews)
3.2
mariadian74

Greetings, I have read your projects carefully, and I would love to do your VBA project. I have experience in all types of online web services such as internet research, data entry, typing, web scraper, etc. I think I More

£25 GBP in 5 days
(3 Reviews)
0.2
hassansharif789

Hello Oliver J., I can work on this project with high accuracy I have completed various projects that includes Data Entry, Data Typing/Conversion, Web scrapping, etc. I'm also good in typing with a speed of over More

£15 GBP in 7 days
(0 Reviews)
0.0
nhannguyen711

Hi. Very happy to bid your project because my skills are fitted in your project. I have been working in c++ and opencv for over 4 years now. I am very familiar with image processing. I have had experience with tasks li More

£15 GBP in 3 days
(0 Reviews)
0.0
thecure473Gmail

hello dear user I have extensive experience in Excel VBA programming, I am qualified to do the job You can review my profile where I detail my experience Best regards

£15 GBP in 1 day
(0 Reviews)
0.0
shamimjibon10

Dear sir,I read your job description.I understand your job description. I have LinkedIn Sales Navigator. If you hire me I will give you 100% Correct work.I am ready to start now. Quality is my top priority. I have 3 ye More

£10 GBP in 2 days
(0 Reviews)
0.0