Adding X Columns for user input based on value of one cell

I have a spreadsheet to enter in data for new users to be added to a system. Depending on the value the entered in C3, I would like the spreadsheet to add additional columns added to the spreadsheet to correspond to the value in C3.

The minimum value of C3=1 and maximum value is 10. Default value is 1. Therefore, one column beginning at C5 will always be present for one users data. If C3=5, I would like 4 additional columns identical to the one beginning at C5 to be inserted in D5, E5, etc.

The header for column C5 has text "User Input #1". I would like additional columns to have the header User Input #X where X is a sequential value up to the value indicated in C3.

Can anyone offer any help with this? I am fairly novice with complex macros.

Thanks!

It would be nice to see an example.

Here's a sample. I would like columns beginning in D5-L5 to appear/disappear pending the value of C3. Maximum value of C3=10, minimum value=1.

Thanks.

Thanks!! It works exactly how I wanted it to.

Hi there. I have a new requirement for this sheet now.

Users are asking me if I can remove cells B8-B24. A simple delete and shift cells left messes up the functionality. Can anyone help with this little tweak?

Thanks!

Hi Holger. Thanks for the response.

I am okay with deleting all of column B from row 8-32 - I don't need those cells at all.
The "Additional Information" is no longer needed and we won't use it in the future but I want to maintain the functionality of adding user input columns dependant on value in C3.

Does this make it any easier?

So close! It almost works, but I need C2 & C3 to remain visible when C3=1. Currently, they disappear if C3=1.

Would it be easier if the text and dropdown in C2 and C3 were moved to a different location like A5 & B5?

Thanks so much Holger. Got a little tied up with other things here at work but I am going to work with this again tomorrow and let you know the results.

Thanks again! Matt

Hey Holger. I did some more fiddling around with the arrangement of the sheet and moved the quantity selection over to column B. Then modified the code to start a couple rows lower and it worked perfectly.

Thanks again for all of your help and advice. Reputation added again