Index/Match hell...

[cheap_ash]

I need to index and match approximately 10,000 rows of data across 7 sheets into one, sorted by date.

This needs to be done dynamically, the data will not be inputted into the massive log but rather one of the 7 other sheets.

Does anyone know of a less laggy way of doing this?

 

[Domenic]

If you download and install the free add-in Morefunc.xll, you can use the THREED function with INDEX/MATCH. For an example, have a look here...

Hope this helps!