"collapsing" data--but only for certain rows
 

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

"collapsing" data--but only for certain rows
 

Try using the Subtotal function. It can then be controlled in a tree control
to show details and hide details.
If you are using Excel 2007 the function is located on the Data tab in the
Outline tools. If you are using Excel 2003 then click Data on the menu bar
and choose Subtotals. This will work if the data is sorted before running
it. Assuming the accounting data has a column of account numbers.




"childofthe1980s" wrote:

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