Very basic VBA user form, to concatenate and populate cells in excel
Budget: £10 – £20 GBP
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.
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.