Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel Macro

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

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

Share: 

 

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.




Tagged: