An Expert from EE was kind enough to provide a solution to a questioin/problem I recently submitted. Functionally the solution works great but in further testing today, I found it's just too slow although I noted that speed was not initially a consideration so my fault for the misdirection. Was hoping someone knew a way to speed up the process?
The attached solution provided by the EE expert compares 2 columns each from 2 sheets (Master and Customer) and pastes the contents from C of the master into a column selected in the Customer sheet.
In the attached example. The search is for the Manufacturer and Model of a car and when a match is found on a row, it pastes the price from column C of the master into the Customer sheet in the selected column.
The problem I ran into is that I have a Master of 151,000 rows and even a small customer list still had 151,000 loops X the number of rows of on the customer list.
Hoping there is a faster way and if there is, i'm sure here is the place where someone would know.
The original question was 2013-01-06 at 22:33:54 ID: 27986700
Thanks in advance.