VBA Script to query all matching in range

[sriley5]

Hi,

I have an data table where a list of Core Products, tied to a ProductID and the quantity. I would like the ability to paste into column A a list of unique ProductID's and with a VBA script pull the matching results onto the same sheet displaying the ProductID, Quantity, and CoreProducts. One trouble I am having is the DataTable has close to 200,000 rows. If anyone has any ideas how I can make this work quickly and efficiently it would be greatly appreciated. Attached is a copy of an example.

[Norie]

Where does the 'Other Data' come from?

This code will get the QuantityPer and CoreProduct data for all the ProductIDs pasted into column A on InputSheet but it won't put the result in the columns indicated on InputSheet (after).

Please Login or Register  to view this content.

[sriley5]

Its pulled from other data sources - Ideally I would like this script to run first to get the product ID's then use multiple Vlookups to reference other data

[sriley5]

I pasted this into the VBA portion of the sheet, but it is not running after the list is updated - can this be written to run in a regular module?

[jindon]

Try

Please Login or Register  to view this content.