Hi I need help to make a macro which in column C merge the text in the cells. There criteria is that it have to merge the text in column C until the next date displayed in column A. So the result could be like below.- I need use on a sheet with very many rows so speed is little important also.
Please have a look also at the test sheet.
1 02.01.2013 textvbkkkakskks -7.506.199,97 NTRF
testssssss
TS CHLAND GMBH 000
EZV9003200200005
Reference 9003200200005
2 02.01.2013 textssssss 25,13 NTRF
goooo28222
GMBH U. CO KG 000
471530250000EUR
Reference NONREF
This is how it looks and i want following result.
1 02.01.2013 textvbkkkakskks,testssssss,TS CHLAND GMBH 000,EZV9003200200005,Reference 9003200200005 -7.506.199,97 NTRF
Maybe with a comma between the text and it change to the next when the next date come in column A.
Please have a look thanks
Sincerely
Abjac
Bookmarks