Excel Help - Macro to cross check 2 columns

July 14, 2011 at 07:19:57
Specs: Windows XP
I have number values in columns F and N and I would like that data to be put onto the same row and then the row to be deleted if the same value appears in both columns F and N;
or if the values are not in both columns that data is copied into a new sheet. The data starts on row 1.


See More: Excel Help - Macro to cross check 2 columns

Report •

July 14, 2011 at 12:55:21
I'm confused.

What data do you want put on the same row?

Is there data in other columns besides F and N? If so, what happens to that data when the values in F and N are lined up?

Perhap you should post some example data of your "before" and "after" so we can see what you are requesting.

Please click on the following line and read the instructions on how to post data in this forum.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question