Merging 2 worksheets in the same workbook

[Guest]

I have 2 different sheets and I am trying to make 1 list by merging. Do I need to merge by column or can I somehow do it by the whole sheet
thanks

 

[Dave Peterson]

Depends on what you mean.

If you have two lists (each one column), then you could

create a new worksheet
copy the first list in A1
copy the second list at the bottom of the first list

Data|Filter|Advanced Filter and click "unique records only" and plop them into
B1.
then delete column A.

Debra Dalgleish has some notes with pictures at:
http://www.contextures.com/xladvfilter01.html#FilterUR

====
if you have multiple columns of other data, you could do the same thing, then
use a bunch of =vlookup()'s to retrieve the columns from each sheet that you
wanted to keep.