I don't even know if this possible as i don't have access to an actual database of items, otherwise i wouldn't be asking for help...

anyways, what i am doing is filling a sheet with 2 colums of information. I am gathering this information from http://www.costcentral.com/product-l...etgear/Z03926/

I must click into each item seperately to get the correct data i need. Once inside the item, i collect the mfg part # and the cost central item #. The cost central item # goes into column B with the corresponding mfg part # into column C.

The tricky part is i don't kneed all items at once. One time i will collect all netgear items, the next i will collect all HP monitors, etc. so the search or filters will be useful.

If this is not even possible with excel because i have no access to the database of items, sorry for the inconveniences.