How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 30129
Experience:  Over 15 year experience resolving Microsoft Office Issues
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

How do I use the same data from a Userform to populate Multiple

This answer was rated:

How do I use the same data from a Userform to populate Multiple rows of a spreadsheet based on a field I have in the userform.

I.E. Item: Broom Cost 100.00 Qty 3
I want to see
Broom 100.00
Broom 100.00
Broom 100.00
Thank you for your question, my name is Richard.

Can I look at your sheet please and I can see how the form is constructed?

- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Thank you
Customer: replied 3 years ago.

File Number is XXXXX

Thank you

I have the file.

Can you tell me where the user form is please

and exactly what you want to accomplish.

Thank you
Customer: replied 3 years ago.

It is in the Visual Basic side of things right now, its is UserForm1

Thanks, XXXXX XXXXX want data from the fields to go into a number of rows correct?

Which rows in which sheets?

Customer: replied 3 years ago.

That is correct, so if I enter the data and select a qty of 3 I want that to populate 3 rows in the Schedule tab, then got to the next line and await more data entry

Thanks David

I did this for you. you can download from using File ID


The code works, you just need to add the rest of the fields to write to the sheet. I did it for Facility so you can see how this is done.

If you have any problems, or would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you
Richard and 3 other Microsoft Office Specialists are ready to help you