Hello,
I am trying to write code that will search for a specific data, such as a part # and then write another set of fixed data into the adjacent cell. For instance, if:
If A:1 = "ABC" then B:1 = "abc123"
If C:3 = "BCD" then D:3 = "bcd234"
-Where"ABC" and "BCD" would be part #'s, and "abc123" and "bcd234" could be a description, vender #, etc.
I would prefer that the logic would work no matter what column the part # is in.
In other words, I am trying to automatically fill in the description/other info whenever a user of the application enters a part #.
Thanks in advance,
James