This code I'm developing (my first VBA script) essentially works, but given real-world data attached to it, will be inefficient and likely slow.
There is a reference sheet called "markers" containing 25000 lines (example attached only has 20) that need to be cross-referenced to about 30000 data points. Currently my code would need to read the 25000 lines at each of the 30000 data points getting cross-referenced. But, I'm sure there's a better way.
Can you show me how to read the reference arrays in worksheet "markers" just one time (from what I've read I think this would need to be done outside of the UDF or with Public scope - not clear to me), while my UDF is called repeatedly and makes use of those arrays to make evaluations in worksheets "A" and "B" (see range A7:A16 in both those workseets).
Thanks!
Bookmarks