Way to insert/paste frequently used values?

[leemoreau]

Hi everyone,



I have a quote template I made in word using userform with VB to insert company info, sales rep etc and it works great. I'm not super technical but it's easy enough to figure out. I'm trying to find a way to insert products into a table, so mainly the product description, then the rep types in quantity, price etc, or possibly types that into the userform as well. I originally made this by having a quote default to showing 5 product lines, then in the userform users would pick or type in each product and it would fill it out. The problem of course is that not all quotes have 5 line items, some have 1 some have 6. Was wondering if anyone knows of a guide online or a reference they can point me to where it might have an example of what I want to do. Ideally what I'd like is maybe the userform to even have 10 line items, so description quantity and price. If they fill in just 1 product, then the word document only uses the one, and then the "grand total" price column adds up the price quantity for 1. If they fill in 3 products, then the word document uses 3 only and then my grand total price variable adds up the grand total price for 3 products etc. Just not sure how I'd accomplish that so wanted to check what I should be looking for. Thank you!

[OTPM]

Hi
Given the information you have provided you would be better doing this in excel. That way you can have hidden formulae that picks up values as and when a user enters a particular value.
If you can provide a sample of your data and layout I will put together a sample in Excel for you to consider.
Tony