Check if a Value Exists in Multiple Columns w/VBA

[JarekM]

Hi, I have a column of stuff with over 10,000 rows. I need to use VBA to check if a variable matches any of the values in a few of the columns. I need to check if row values in 2 columns match, then return specific value in corresponding row of another column. Basically, it will check to see if there is any matching values for Store Sku# and there is matching values, then it will check to see if there are any matching values for City, if there are matching values then finally it will check the unit price, if the unit price is different then it should save that row to TbHistory sheet and then update the unit price to the current price of the item in TbProduct sheet. If the values match for Store Sku#, but not for city, then it should just save the item as a new one in TbProduct sheet.

Please, I need help coming up with VBA, please let me know if anything needs to be clarified!

 

[James006]

Hi,

With VBA Find, you can design exactly your fully customized solution :

Excel VBA Find: 20 Examples to Search and Find with Macros

Quickly learn to search and find different items/information using macros. 20 easy-to-adjust step by step VBA code examples you can use right now.

powerspreadsheets.com