I have to sort and keep a lot of data up-to-date for a specific excel file. I setup a slew of index/match commands referencing two other spreadsheets so that I could have a continously updated file to keep my data accurate.
It worked great for my test page because of the limited amount of cells... But when I applied it to the actual file it takes an eternity for excel to do anything! I understand its a huge array and that's why but there has to be a way to do this.
Is there a way for excel to even take all the data I collected from the files and print it to a spreadsheet where there are just values in the cells and not something it has to compute/reference. I'd be happy to copy and paste the whole spreadsheet if that's what it takes.
I don't need to access this file on the daily, but everything is very dynamic and there's no way I'm updating a 18000x250 array manually.

Any ideas or suggestions are highly welcomed and extremely appreciated