Thanks Shrivallabha!
The macro is working fine but after running it "Type Mismatch" alert is shown and then it is giving the correct result.
I am not familiar with this macro/ coding so it is hard for me to use for obtaining results for about 1000 rows containing different textual...
Hi,
I need your help on how to get multiple rows data into one cell.
Date Data Result
01/01/2013 A A, B, 500
B
500
02/01/2013 C C, D, E,600
D
E
600
03/01/2013...