Excel VBA ARRAY Loop to Database

I have a huge challenge which is: Search a massive database, a list of products. This database is divided into 3 dif. sheets. The result should be stored on a 4th sheet and organized by date in columns and summarized by quantity. Each database sheet has the same format (Product / Date / Quantity). I was told that a vba array would work perfectly. Any help will be very appreciated. Thanksenter image description here

https://stackoverflow.com/questions/65780996/excel-vba-array-loop-to-database January 19, 2021 at 03:34AM