MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel Macro

  Asked By: Cody    Date: Mar 25    Category: MS Office    Views: 1091

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
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



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Excel Macro Or get search suggestion and latest updates.