Macro to Fill out form

Hello there,

I would like to create a macro that fills out this form.

Basically what I want to do is fill the information with column D.

For example: E: Should be 23 till it gets to the number of column B

The numbers highlighted in yellow are the examples

Hi, have you re-read your own post?
Please do so and try again.

I guess if would, it's explained in the Forum banner but just in case ...

You're doing something wrong? Getting an error message?
Dropbox worked but you should be able to attach files to the post too

There’s a button upload and then close window

There is either an error message or a reason why a file cannot be uploaded

I get an error.
No go

I'm glad you managed to attach the file. Noe the next important thing.
What do you want, your question and the file; maybe I'm reading something wrong but I do not understand what you want.
You speak about a form and I only see a worksheet with many columns that don't explain what they mean.
The first columns with all the values, what's the relation to the Box Case x columns?
Maybe you should try a pivot table for the columns A-E ?
I don't know, it's not clear. Sorry.

How about trying it out yourself, you've got enough answers all you're asking now is variations on the same theme.
@Jindon is great at this, but don't make yourself dependant on others, try it yourself and if you then don't get any further ... HELP!

Happy coding

Originally Posted by ACCABT

Can you please help me generate a similar macro but for this particular sheet, it is almost the same.

The only difference is that we need a column with "not needed" between every other column.

Upload a workbook with correct data layouts and the result that you want.
It should be EXACT data layouts this time.

Concentrate on your problem.