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