Apr 07 2021 05:36 PM
Apr 07 2021 09:11 PM
@Constiel If I were you, I would stick to the one-list approach. The worst thing to do is start creating monthly sheets. Excel is very good at taking big quantities of structured data and then summarise or reorganise it in seconds.
Begin by looking into Pivot Tables. There are many tutorials on-line and they are not very difficult to learn to work with. If needed, come back here with a file containing your data (remove any private and confidential information though), and I or someone else here can help you further.