Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
65
Views
Topic starter
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?
Posted : 06/12/2018 9:43 pm
Hello Julie,
A general answer is to use Power Query for this.
https://www.myonlinetraininghub.com/power-query-and-power-pivot-definitive-guide
Posted : 07/12/2018 2:16 am
