we want to add/concatenate the values of first column and show the result in next column. The problem is fully explained in the comment section of the sheet attached. But still if you are having in getting the problem, then plz let me know
we want to add/concatenate the values of first column and show the result in next column. The problem is fully explained in the comment section of the sheet attached. But still if you are having in getting the problem, then plz let me know
You could do it with formula, but probably much easier is short macro similar to this one (see also attachment - there is a bit quicker version, but results are the same):
Please Login or Register to view this content.
Last edited by Kaper; 02-04-2014 at 06:30 AM.
Best Regards,
Kaper
Maximum of 5 Input data values?
no it has numerous values...i added only 5 to look it easy...........
It seems the best fix has already been compelted and done for you.
hey thnx, it really worked for me. but can u plz modify it to have desired ouput as in new attached sheet.......plz let me know if you have any other query.
OK, I am doing next step, but still there is a room for you to DIY
have a look on the attached workbook and two macros - Test3 is as you described in the sample but I do think that what you really need is macro test2 which generates more output. (my way ;-) )
As you can see - it works with 2,3 and 4 pieces sets - you can easily prepare 5 and more yourself based on the above and clearly marked places when it was necessary to make changes. If you indeed need "your way - it will be easier to do. If "my way", notice that new variable is used as a most inner loop each time.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks