Hello folks. Been searching but haven't found anything quite getting me what I need.
I have a spreadsheet with 2 tabs on it. First tab is titled "test list", this contains a short list of part numbers
Second tab is where the customer enters their data in cell A1. This is a part number. If that part number exists on tab 1, range A1:A21, I need it to pop up a message box warning them that they're moving the wrong product.
Is this even possible? I can't find something to point it to a range on a different tab.
Thanks in advance!
I have a spreadsheet with 2 tabs on it. First tab is titled "test list", this contains a short list of part numbers
Second tab is where the customer enters their data in cell A1. This is a part number. If that part number exists on tab 1, range A1:A21, I need it to pop up a message box warning them that they're moving the wrong product.
Is this even possible? I can't find something to point it to a range on a different tab.
Thanks in advance!