I have two two matrices. Matrix-2 with 170 rows and two columns. Each cellfilled with 13 digit Numbers and Columns-2 has counts the number of times cellvalue repaeted.Matrix-1 has 430 rows. Columns have 13 digit no. and reference(Text) for eachcell.How can I write Excel macros, which will check both matrix and print thereference values(Text) for each corresponding cell opposite matrix-2. eg.Matrix-11 A2 B3 A4 C5 BMatrix-2A 2B 2C 1I want Excel macro to write Marix-3 as output containing:A 1,3B 2 5C 4Any Idea?
You will need to have an outer loop which steps through each or the rows inmatrix-2 and picks up the values.Within this you will need an inner loop which steps through each row in matrix1 and looks for the values.When it finds a matching value it needs to copy the cell immediately to theleft 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 sortout your problems.
First suggestion is not to use a subject "Suggestion needed". Use ameaningful 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 ityourself. :-) :-)Exactly which part of this need are you having trouble with? Passing thetwo ranges as parameters to the subroutine or using named ranges? Workingdown the rows of the second table? Working down the rows of the first tableand detecting that the row on the second table matches the info on the rowin the first table? Concatenating information into a string?Please make a start on it, then post your code if it doesn't work, includingspecific questions about what's happening and what you want to happen.(Plus a new Subject line.)
Thanks. I am new at Excel Macros. I was using Excel functions to do this. Canyou tell me the macro for this problem.
It looks as though you have some programming experience,,,,,May we ask what programming language?
No. Not at all. I want help on writing macros for this.