Hello members. Second time coming to the well; appreciate the help of course!
What I want to do is add new entries to the list on the fly if they are not present. I have found methods to add one data point but I want to add all three.
Thanks in advance for any advice!
Andrew
- I have a list on a (sheet 3) with three columns
- A = NAME
- B = PHONE
- C = EMAIL
- On (sheet 2) I have a cell B2 with data validation connected to Column A (NAME)
- On (sheet 1), the result of whats in (Sheet2, B2) appears in a cell and thru vlookup, the phone and email are pulled right under the name
What I want to do is add new entries to the list on the fly if they are not present. I have found methods to add one data point but I want to add all three.
Thanks in advance for any advice!
Andrew