Help! Easy Macro - Find and Print
 

Hi programmers,

I have a long list of data on a single sheet. Each row has a grouping
number, e.g. 1, 2, 3, etc. I want to write code that will take all
rows with the same grouping number and print them on a separate page.
Some of the columns are used only for calculations and so they are
hidden and I don't want them to be printed.

This data is linked to a pivot table and a pivot chart. I'd like to be
able to print off the corresponding chart to go along with each data
group as well.

These pages are reports that will be sent off to different people
within the company, so I'd like them to be formatted somewhat nicely.
Would this be done through the code as well?

Thanks for the help,

Chris

Help! Easy Macro - Find and Print
 

nt

Help! Easy Macro - Find and Print
 

it may sound easy to you, but it certainly doesn't to me! it's at
least four smaller sized projects combined into one big one.
:)
susan


On Aug 2, 11:18 am, Chris wrote:
Hi programmers,

I have a long list of data on a single sheet. Each row has a grouping
number, e.g. 1, 2, 3, etc. I want to write code that will take all
rows with the same grouping number and print them on a separate page.
Some of the columns are used only for calculations and so they are
hidden and I don't want them to be printed.

This data is linked to a pivot table and a pivot chart. I'd like to be
able to print off the corresponding chart to go along with each data
group as well.

These pages are reports that will be sent off to different people
within the company, so I'd like them to be formatted somewhat nicely.
Would this be done through the code as well?

Thanks for the help,

Chris