Greetings,
I would like to express my thanks in advance for any help that is provided. I have a data management problem. I built a sheet that takes a significant amount of data from 2 different sources at the end of every month. I built a comparison table using array formulas to pull data from each source depending on certain criteria in order to seek out any discrepancies. With the kind help of this forum, I also built macros to make use of this data. To my dismay, I have found out that array formulas slow performance considerably. The source of my data is about 10,000 lines, therefore; it has become more difficult than efficient to deal with my spreadsheet. I was wandering if there are any suggestions to pull data from a raw source depending of defined criteria such as day of the month, product name, hour of the day, etc. I have heard that data can be placed in a database in Excel, however, I am not at all familiar with this kind of data handling. If someone can point me in the right direction, I am willing to put in the work that might be needed. Thank you