So I abandoned any further attempt to use the displayed output in any calculations.
For Table 9a.
The displayed output shows a number in the same cell as the dropdown. I type that number into the ITEM N.E.W. field.
The TOTAL N.E.W. field calculates the total (=UXOQTY1 * UXONEW1). This seems to be working.
For Table 9b.
The displayed output shows a number in the same cell as the dropdown. I type that number into the ITEM N.E.W. field.
The TOTAL N.E.W. field calculates the total (=DEMOQTY1 * DEMONEW1). This seems to be working.
Each ITEM N.E.W. text field has a run on exit macro which is supposed to give the option to add another table row.
Both are standalone tables with no merged cells, so I used the =SUM(ABOVE) to add up the numbers in the cells above it. That seems to be working as long as I don't use merged cells. If I do, it throws everything off.
For the table below those two (TOTAL NET EXPLOSIVE WEIGHT CONSUMED) I used the bookmarks for the previous totals to get a "grand total". That isn't working. I would simply add all of the formulas from the individual cells, but that wouldn't work if the ADD ROW option worked unless I added more formulas than I expected to ever need.
|