Copy calculated total from cell in one table to another table
I am using Graham Mayor's mail merge utility "Many-to-One" to generate several hundred purchase orders. Each purchase order has a varying number of items for which the total cost is calculated in the last row of the table. I need to put the total from this table into a cell on a summary table. The macro to copy the contents of a cell in one table to a cell in another table doesn't work because the cell address of the "total" varies with the number of items on the purchase order.
Is there a solution?
|