Adding Table Rows based on User Form Entry

Question

Adding Table Rows based on User Form Entry

Anonymous

I want the user to enter how many loads they want to add to the table... for example 25. I then at the bottom of my table, want 25 rows added. Is this possible through a form? Or maybe just a macro?

User Form:

How Many loads

Submit

Cancel

Table Name: GODSOY

SheetName: Sheet1

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Answer 1

Hi Myatt

It is difficult to visualize and/or reproduce your scenario and requirement with the current information, your worksheet is too complex to give you a solution without having access to your file.

Kindly suggest preparing and uploading a sample file to Onedrive, Dropbox, etc.... and share the link here.

Please first,

a) Remove any personal/sensitive data.

b) Keep the headers, table structure, and formulas as they actually are.

This will help us to give you a prompt and suitable solution.

If you need help with how to upload the file please, click the link below

https://support.office.com/en-us/article/share-onedrive-files-and-folders-9fcc2f7d-de0c-4cec-93b0-a82024800c07

You may also follow the instructions in this video

https://www.youtube.com/watch?v=NnXsE0SNuCc&t=14s

Regards

Jeovany

Share via

Adding Table Rows based on User Form Entry

1 answer