Pivot tables are about as close as you'll get. Unless you want to treat the
same workbook as a Jet SQL source and query it.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Steve W" wrote in message
...
Hi,

I've a lot of csv files to process. In each one I need to summ some
columns where one or two other columns are the same.
In a database table this would be easy using a SQL 'group by' statement.
Is there a similar method I could use in VBA?

Thanks in advance
SW