Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Workbook Set-Up Questions
Hi,
I need some ideas on the best way to set up an Excel workbook for the following scenario: I receive a .csv file weekly that contains 20 colleague names (this number fluctuates weekly) with 30 data points that need to be tracked. The file contains my colleagues' names as a "row label" in column A (beginning in cell A:2) and each of the 30 data points as column labels (beginning in cell B:1). I need to track this data each week throughout the year. I have several questions: Is it best to set up one worksheet for each colleague or one worksheet for each week and then a "summary" sheet for each colleague? Since the "row labels" (ie, number of colleagues) change each week is there a way to "consolidate" (hlookup?) or write a macro so that each row of data is copied into the appropriate worksheet automatically (assuming there's a worksheet for each colleague)? Using a database program is not an option, management requires an Excel workbook. The goal here is to provide each colleague with a weekly report of their performance (the 30 data points) over time but to do it as effeciently as possible so that I'm not spending half a day copying and pasting from worksheet to another. Any suggestions and recommendations are appreciated. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Repost:Automatically inserting a row in external workbook | Excel Discussion (Misc queries) | |||
keeping a toolbar attached to a workbook | Excel Discussion (Misc queries) | |||
Find a value in a workbook and return the worksheet name | Excel Discussion (Misc queries) | |||
Unprotect Workbook | Excel Discussion (Misc queries) |