Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summary worksheet Scorecard
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summary worksheet Scorecard
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 "Marilyn" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with worksheet table and summary | Excel Discussion (Misc queries) | |||
Summary worksheet question | Excel Discussion (Misc queries) | |||
summary data sheet from worksheet to worksheet | Excel Worksheet Functions | |||
Link worksheet totals to a summary worksheet in the same workbook | Excel Worksheet Functions | |||
Creating a Summary Worksheet | Excel Worksheet Functions |