Hello all,
I am quite new to VBA scripting. Here is what I am struggling with.
Example :
Data : I have two sheets A and B.
A contains the data from customers. B contains data from me.
Question : Once the customer selects production/market in sheet A, I want to iterate through the rows in sheet A and check if the data in each row (combined- all three words) matches with the column A in sheet B.
If it does not match (Eg: Row 3 in Sheet A), then create another row below with the word plastic cup.
Any leads, links or help would be really helpful.
Thank you very much
I am quite new to VBA scripting. Here is what I am struggling with.
Example :
Data : I have two sheets A and B.
A contains the data from customers. B contains data from me.
Question : Once the customer selects production/market in sheet A, I want to iterate through the rows in sheet A and check if the data in each row (combined- all three words) matches with the column A in sheet B.
If it does not match (Eg: Row 3 in Sheet A), then create another row below with the word plastic cup.
Any leads, links or help would be really helpful.
Thank you very much