copy subtotal information to new sheet
 

I have a list of customers from different countries. I subtotaled the country
column to count how many records there are for each country... now I need to
chart the subtotal information. I wanted to copy and paste it to a new sheet,
sort, and chart from there. Can I do that? If not, is there another way to
accomplish my goal?

thanks!

Hi
when only showing subtotals only level select edit go to special select
visible cells only click ok then copy this data paste on new sheet
Tina


"Patience" wrote:

I have a list of customers from different countries. I subtotaled the country
column to count how many records there are for each country... now I need to
chart the subtotal information. I wanted to copy and paste it to a new sheet,
sort, and chart from there. Can I do that? If not, is there another way to
accomplish my goal?

thanks!

Tina

This info is so helpful. I've been trying for so long to figure this out.

Thank you, thank you, thank you!

Tania

"tina" wrote:

Hi
when only showing subtotals only level select edit go to special select
visible cells only click ok then copy this data paste on new sheet
Tina


"Patience" wrote:

I have a list of customers from different countries. I subtotaled the country
column to count how many records there are for each country... now I need to
chart the subtotal information. I wanted to copy and paste it to a new sheet,
sort, and chart from there. Can I do that? If not, is there another way to
accomplish my goal?

thanks!