YellowLabPro
12-15-2006, 09:58 AM
I am interested in comparing two lists. There will be two criteria's to consider- 1) if the control list, list (A) does not contain an item that exists in list (B), then copy this item to a third list, list (C). If the item exists in both lists and is greater than zero (0) then copy that item to the third list, list (C).
My question is can VBA do this, if so where and how would I start this?
This project is for my online store. Our inventory contantly changes and I need to update, add and delete item records daily. Currently I just do a mass replacement, but w/ over 10,000 records, it takes about 2 hours to do all the checking and replacing.
Thanks,
YLP
My question is can VBA do this, if so where and how would I start this?
This project is for my online store. Our inventory contantly changes and I need to update, add and delete item records daily. Currently I just do a mass replacement, but w/ over 10,000 records, it takes about 2 hours to do all the checking and replacing.
Thanks,
YLP