bydo
08-05-2014, 08:06 AM
Hello,
please have a quick look at my attachment: I need to fill the columns B-D of the sheet "starting data" with the values matching
the IDs of the sheet "reference". The result should look like shown in sheet "result after code".
You can also find my somewhat working solution inside (press the arrow), but its performance is too bad, it takes several minutes
to run on the actual lists wich contain 20,000 - 30,000 rows each, wich is not acceptable.
Can you guys help me out with a better working solution to my problem?
please have a quick look at my attachment: I need to fill the columns B-D of the sheet "starting data" with the values matching
the IDs of the sheet "reference". The result should look like shown in sheet "result after code".
You can also find my somewhat working solution inside (press the arrow), but its performance is too bad, it takes several minutes
to run on the actual lists wich contain 20,000 - 30,000 rows each, wich is not acceptable.
Can you guys help me out with a better working solution to my problem?