Check if Value Existing in Multiple Column with Criteria

[JarekM]

Hi, I am attaching a screenshot below for reference. I have a data table with items, I have a column of numbers of over 10,000 rows. Before I add a new item to the table, I need to use VBA to check if STORE SKU# matches with pre-existing STORE SKU# and if so then it will check the city and if the city matches as well then it will look at the unit price in the column (such as in the sample) and if the unit price is different then it should save the row to TbHistory sheet and then update the price to the current price in the TbProduct sheet. This should be done if both criteria are met, so if STORE SKU# match and city. If the STORE SKU# matches but not city, then it should just save it as a new product in TBProduct sheet.

Can someone please help me and please let me know if I need to clarify anything?

 

[zero269]

Hi, I am attaching a screenshot below for reference. I have a data table with items, I have a column of numbers of over 10,000 rows. Before I add a new item to the table, I need to use VBA to check if STORE SKU# matches with pre-existing STORE SKU# and if so then it will check the city and if the city matches as well then it will look at the unit price in the column (such as in the sample) and if the unit price is different then it should save the row to TbHistory sheet and then update the price to the current price in the TbProduct sheet. This should be done if both criteria are met, so if STORE SKU# match and city. If the STORE SKU# matches but not city, then it should just save it as a new product in TBProduct sheet.

Can someone please help me and please let me know if I need to clarify anything?

View attachment 84208

Can you try sharing your data again using this forums Excel Add-in?

VBA check if active cell is empty

I'm not sure why I can't get this to work. I need to abort the macro if the active cell is empty. I've tried: If ActiveCell.Value = "" Then Exit Sub and If IsEmpty(ActiveCell) Then Exit Sub but neither work. I've found other solutions that test for a particular cell (A1 for example), but I...

www.mrexcel.com

It makes it much easier to get the information people need to help you.
Best regards,

 

[JarekM]

Can you try sharing your data again using this forums Excel Add-in?

VBA check if active cell is empty

I'm not sure why I can't get this to work. I need to abort the macro if the active cell is empty. I've tried: If ActiveCell.Value = "" Then Exit Sub and If IsEmpty(ActiveCell) Then Exit Sub but neither work. I've found other solutions that test for a particular cell (A1 for example), but I...

www.mrexcel.com

It makes it much easier to get the information people need to help you.
Best regards,

Hi, I am not sure as to what you are looking for. Should I resend the screenshot? If you are wondering about code, then I don't have any. I am looking for code that would do what I said in my first message.