Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: John Cooper   on Nov 12 In MS Office Category.

  
Question Answered By: Jae Williams   on Nov 12

You will need to have an outer loop which steps through each or the rows in
matrix-2 and picks up the values.

Within this you will need an inner loop which steps through each row in matrix
1 and looks for the values.

When it finds a matching value it needs to copy the cell immediately to the
left and paste the value in the next blank in the row in Matrix-3.

If you have problems when you try this post your code and we can help you sort
out your problems.

Share: