I would like to be able to lookup information from worksheet-B (History) and automatically insert N number of rows found from worksheet-B into worksheet-A (Tool). The number of lines inserted need to sum the total amount.
The user will enter From and To dates and the Tool will cross reference each corresponding worksheet and insert rows with the information found and autosum the subtotal. Tool: https://i.imgur.com/RRRXhDy.png
Here is what the final result should appear as based on the From / To dates entered. Result: https://i.imgur.com/h0Jo9MN.png
I've attempted the following yet been unsuccessful. 1. Pivot table approach 2. INDEX approach 3. VLOOKUP approach
However the end result is that the rows inserted don't automatically sort correctly and the subtotal won't automatically update.
Any advise is greatly appreciated.