copy subtotal information to new sheet

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

[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


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

[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

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

[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

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

[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

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

[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

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

[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

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

[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

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

[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

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

[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

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

[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

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

[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

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