How could I accomplish the below scenerio:
I have three columns in the same worksheet:
Column A, Column B, and Column C.
Column A and B contain 15 didget numbers and Column C contains 7
didget number.
Column A contains certain number, and Column B contains certain
number.
Most of the numbers in Column A & B match.
I want to compare Column's B & A and if the numbers don't match,
I want to shift cell in column B and Cdown till it finds a match
in Column A so that Column B matches Column A and also at the same
time move the corresponding value in Column C down with the Column B
that is being moved down.
I would like all of this to be done automatically. using Excel Macro