copy subtotal information to new sheet

P

Patience

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!
 
T

tina

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
 
T

Tania

Tina

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

Thank you, thank you, thank you!

Tania
 
Top