One simple formulas play to tinker with, John ..
Illustrated in this sample:
http://www.freefilehosting.net/download/3bb2k
Automatic Merge.xls
Assume source data in cols A to D, data from row2 down
Let's make use of say, the "Fecha Valor" col in col C
Enter something in the cell just below the last data row,
eg enter in C10: end
Then put
in E2: =IF(C3="",D2&" "&D3,"")
in F2: =IF(AND(C2<"",E2=""),D2,E2)
Select E2:F2, copy down to the last row of source data. Col F returns the
desired results, which you can freeze using an "in-place" copy n paste
special as values
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---