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