Macro HEEEELP

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi I am comparing two lists in excel. The first list contains part
numbers and it is my list. The next list contains part numbers and it
is the customer's list. I have compared both lists to determine what
the customer has and what I have. If the customer has it and I have it,
then the formular returns "yes" if not then "no." I would like to
create a macro that cuts and pastes the "no's" into a new column.

The Data is organized as follows

Customer Data (cells 2 thru cells 584)
Column A
Part No.
102634
..
..
..
-------------
My Data (cells 2 thru cells 953)
Column D
Part No.
102635
..
..
..
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

matching & combining data from seperate worksheets 2
Lookup and Display Multiple Unique values based on criteria 7
What type of "lookup" 3
Using list choices to use as headers 3
Sorting day names chronologically 5
MATCH function not matching as expected 10
matching and entering data 3
Formatted cell column in drop down list 1

Back
Top