I'm trying to create a dynamic form where by information is pulled from another worksheet and displayed in a master report. I have a cell that contains the number of transactions found based on FROM and TO dates (i.e. 3 transactions found between these dates).
<tbody>
</tbody>
The row where z1, z2, z3, z4 reside I need to first copy this row below 2 more times, then copy the formulas from z1, z2, z3, z4 down as well to replicate the 10 transactions of data being pulled from the other worksheet.
<tbody>
</tbody>
Later the user can modify the FROM / TO dates and it will look up the number of transactions so the "displayed rows" needs to update dynamically to the new value (i.e. 5).
I haven't figured out how to do this without braking the information (array) in the z* cells.
Any ideas?
From | 01/01/19 | ||
To | 01/31/19 | ||
Transactions | 3 | ||
Date | Description | Qty. | Cost |
z1 | z2 | z3 | z4 |
Subtotal | $ |
<tbody>
</tbody>
The row where z1, z2, z3, z4 reside I need to first copy this row below 2 more times, then copy the formulas from z1, z2, z3, z4 down as well to replicate the 10 transactions of data being pulled from the other worksheet.
From | 01/01/19 | ||
To | 01/31/19 | ||
Transactions | 3 | ||
Date | Description | Qty. | Cost |
z1.a | z2.a | z3.a | z4.a |
z1.b | z2.b | z3.b | z4.b |
z1.c | z2.c | z3.c | z4.c |
Subtotal | $ |
<tbody>
</tbody>
Later the user can modify the FROM / TO dates and it will look up the number of transactions so the "displayed rows" needs to update dynamically to the new value (i.e. 5).
I haven't figured out how to do this without braking the information (array) in the z* cells.
Any ideas?