Need HELP, Excel experts!!@#@!#

IronFar

Member
Mar 24, 2003
163
0
0
Got two sheets, need to weed one duplicates of a field from one sheet to the other. Doesn't matter which sheet the original appears in. just as long as ONE appears in either of the two sheets.

How do I go about this?

Thanks!!!
 

LANMAN

Platinum Member
Oct 10, 1999
2,903
134
106
:roll:

Use your control key and click on every cell you want to move; Cut and paste into second sheet.

If that's not it, repost becuase your question is very confusing.

--LANMAN
 

lykaon78

Golden Member
Sep 5, 2001
1,174
9
81
<In my best Hank from King of the Hill> What!?

Please explain or correct your grammar.
 

JulesMaximus

No Lifer
Jul 3, 2003
74,586
986
126
I have a macro that compares the current cell to the cell above and if the data is the same it deletes the entire row.