Hi all,
Does anyone have a magic formula for my problem?
I have many worksheets (weekly internal reports) with lists of employees and a particular assigned number to each person (a number between 0-10 based on units processed). The worksheet has multiple sheets (or tabs) where the employees can be listed - but they are always on the same column (col C). The number assigned to each person is in the same row, but in column M.
What I need to do is have one file with the employees listed, and an average of the number. The file already has the employees listed, the numbers themselves need to be imported for calculation.
Is there a Macro that will look up the names in the closed files, extract the numbers and move them to the new file and work out an average?
The weekly files have the same name format except the date at the end:
Weekly_Report_2011_07_08.xlsx
I know it's quite complicated, so even a marco to extract the numbers and list them in the single file is a great help already.
Thanks all!
Does anyone have a magic formula for my problem?
I have many worksheets (weekly internal reports) with lists of employees and a particular assigned number to each person (a number between 0-10 based on units processed). The worksheet has multiple sheets (or tabs) where the employees can be listed - but they are always on the same column (col C). The number assigned to each person is in the same row, but in column M.
What I need to do is have one file with the employees listed, and an average of the number. The file already has the employees listed, the numbers themselves need to be imported for calculation.
Is there a Macro that will look up the names in the closed files, extract the numbers and move them to the new file and work out an average?
The weekly files have the same name format except the date at the end:
Weekly_Report_2011_07_08.xlsx
I know it's quite complicated, so even a marco to extract the numbers and list them in the single file is a great help already.
Thanks all!
