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!
Please, I need help coming up with VBA, please let me know if anything needs to be clarified!