November 8, 2018
I have a workbook that creates a new sheet every week with a macro. I would like to be able to figure out how much I have bought and sold of each card. What is the best way to do this? How do I grab it from the new sheet each week?
I would also like to create a report each month that sums up what we ordered, sold publicly, sold at wholesale, and checking account information. Any ideas on the best way to do this?
December 7, 2016
A general answer is to use Power Query for this.