Hello:

I have a spreadsheet that contains accounting data that I exported from a
separate application. The spreadsheet contains a column called "Series".
The rows in this column are designated by such phrases as "Sales",
"Purchasing", and "Financial".

For "Sales" rows, I want to have Excel automatically remove data from three
columns and "collapse" the data in the other columns. When I say "collapse",
I mean eliminate the duplicate data in each row so that only one row contains
the data.

In effect, "Sales" rows will be summarized while "Purchasing" and
"Financial" rows wil contain the detail.

This is hard to explain and take in, I know. But, if anyone has any ideas
on what sort of macro can be created to summarize data for just certain rows
within a spreadsheet, I would love to hear them.

Thanks!

childofthe1980s