I've developed an Excel order form for use on a Surface Pro 8 tablet. The form consists of header information (customer address, etc), footer information (notes, etc.) and product order lines in between. The order line cells contain formulas that reference macros and another worksheet to pull in product information and prices. I am looking for a simple way to add one or more additional rows, as needed, that will pull in the formulas. Ideally, the user could click a button to add one or more rows below the last product order line.
The problem is that the user can override cell contents to manually enter items that are not on the secondary sheet, and that will break some of the existing methods of doing this. I looking for suggestions on how to handle this situation. Any thoughts?