Hi Everyone
I have a huge database with Products, Quantities and Dates. The macro goes through this database (sheet "Data") and distribute them into the "Summary" sheet.
The loop is already created and it's running fine but it's taking too long (more than a hour) to cover the whole file. There are several loops in the same macro checking different data. What I'm trying to find another method to speed it up. Attached is a sample file with the loop and a sample data.
Any help will be very appreciated.
I will describe below a sample of a loop I'm using today.
Bookmarks