Hello,
Hope you are doing fine.
I have an example for which i would require a macro to solve, attaching the example file for your reference.
There are prod. plant codes in Col A and in row 1 we have 12 products codes. For each plant code if we find matched products then we are suppose to merge the product codes in a single cell next to Plant code. it'll clear when you see the attached excel file.
Regards,
Rajkumar
Put this function in a standard code module
Put this formula in Q2 and copy down
Please Login or Register to view this content.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Check your data.
In row 12, D12 and I12 both say Matched (against 01CV and 01LA) but the result in Q12 only says 01CV ?
Q14 says 01BV but B14 (01BV) says Not matched. D14 (01CV) is in fact matched but theres no reference to this in Q14 ?
B15 Says Matched for 01BV but Q15 says 01FC which is not matched in that row ?
Row 16 is a complete mess, 01CV 01FF 01HT 01NW 01SL are all matched yet Q16 only has 01LA which is not matched at all ?
Row 17 check D17 and Q17 result
Row 18 check the Matched against Q18 results
Row 19 check it
Row 20 check it also
Row 21 again check this
Row 22 wrong again check it
Row 23 check it
Row 24 ....HOORAY! WE HAVE A WINNER, ITS FRIGGING CORRECT!!
Row 25 Here we go again, its wrong
Row 26 Not sure what you done here, check it
Row 27 wrong again
Row 28 ...WHY NOT END ON A CORRECT ROW! Thank god!
Why do we have to check people's data on this forum before solving a problem?
It should be correct in the first place!!
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thanks Alpha Its working great. Can i ask you instead of Function can you help with using Array vba coding.
Originally Posted by Rajkumar_h
Please Login or Register to view this content.
Thanks Alpha, This is what I was looking for and works very fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks