MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Suggestion needed

  Asked By: John    Date: Nov 12    Category: MS Office    Views: 838

I have two two matrices. Matrix-2 with 170 rows and two columns. Each cell
filled with 13 digit Numbers and Columns-2 has counts the number of times cell
value repaeted.

Matrix-1 has 430 rows. Columns have 13 digit no. and reference(Text) for each

How can I write Excel macros, which will check both matrix and print the
reference values(Text) for each corresponding cell opposite matrix-2. eg.
1 A
2 B
3 A
4 C
5 B

A 2
B 2
C 1

I want Excel macro to write Marix-3 as output containing:

A 1,3
B 2 5
C 4

Any Idea?



5 Answers Found

Answer #1    Answered By: Jae Williams     Answered 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.

Answer #2    Answered By: Sadie Black     Answered On: Nov 12

First suggestion  is not to use a subject "Suggestion needed". Use a
meaningful subject if you want answers.

I'm not sure what your question is anyway. "Any Idea?" is pretty useless.
My "idea" would be to hire a professional programmer if you can't do it
yourself. :-) :-)

Exactly which part of this need are you having trouble with? Passing the
two ranges as parameters to the subroutine or using named ranges? Working
down the rows of the second table? Working down the rows of the first table
and detecting that the row on the second table matches the info on the row
in the first table? Concatenating information into a string?

Please make a start on it, then post your code if it doesn't work, including
specific questions about what's happening and what you want to happen.
(Plus a new Subject line.)

Answer #3    Answered By: Viveka Fischer     Answered On: Nov 12

Thanks. I am new at Excel Macros. I was using Excel functions to do this. Can
you tell me the macro for this problem.

Answer #4    Answered By: Cadeo Nguyen     Answered On: Nov 12

It looks as though you have some programming experience,,,,,
May we ask what programming language?

Answer #5    Answered By: Lena Moore     Answered On: Nov 12

No. Not at all. I want help on writing macros for this.

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