i have generated an excel sheet through vb 6.0
it contains four columns and 200 rows
now i want to group the rows on one clolumn which is fx currency
for eg
if 100 rows contains usd as fx curr
i have to group the rows
and if next 100 rows contains euro as fx curr
i have to group these rows
please help in this