Results 1 to 3 of 3

Thread: Getting values off another sheet by references!?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Regular bydo's Avatar
    Joined
    Jul 2014
    Location
    cologne germany
    Posts
    6

    Question Getting values off another sheet by references!?

    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?
    Attached Files Attached Files

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •