Summary worksheet Scorecard

[Guest]

Hello
I have a workwook with 12 worksheets, one for each month of the year. Each
worksheet is a monthly report –e.g “JAN†worksheet - the first column has
the names of the sales personnel ( 30 in total) the rest of the report has
monthly details such as how many sales were phone orders, or faxes, web
orders, etc. What I need to do is created a scorecard for each person. (This
a scorecard that will be given to each sales person) If I create 30
worksheets then do vlookups ,is going to be long long process. I need some
direction..... a faster way to do this Thanks

 

[Guest]

VBA code will help solve your problem. You need to create a summary sheet
and either create links to each worksheet or copy the data into the summary
worksheet.

With 30 salespeople and 12 months that 360 copies or links. A lot of work.
the amount of work increase significantly for each statistic you want placed
on the summary.

Start by creating a sample summary worksheet so you know how you want the
data organized. It looks like it is more complicated than posting the
information on this website and you need the results quickly. E-mail me the
workbook after you put in a sample summary worksheet and I write the macro
tonight (e-mail address removed)