|I would like to amend my previous response. |
You could use VLOOKUP to accomplish your goal, but it would be messy.
If you place this formula at the bottom of your Column B list and drag it down as many cells as you have values in your Column A list of names, it will pull over any name that does not exist. However, it will leave blank cells for any name that already exists in Column B.
Note: $B$1:$B$4 will need to be modified to match your specific range.
In other words, let's say you start with this in SheetX!Column A...
...and this in SheetY!Column B:
6 (Drag B5 down 7 cells to match the length of SheetX!Column A)
You will end up with this:
Obviously you'll need formulas in SheetY!C:G to pull in the rest of the data.
Once all of the data is in SheetY, you could clean it up by doing a Copy...PasteSpecial...Values and then delete the blank Rows using whatever method you prefer (sorting, deleting, filtering, etc.)
I hope that helps.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
message edited by DerbyDad03