Hi,
I have a raport for each week of the year (each week in a different sheet) of our companys service efficiency. Now i´m trying to write a macro that counts the avarage of each store or the stores the user has selected.
I´ve managed to make a userform where the user can select the stores he wants counted. Open the needed file and list the sheets in the file to a listbox where the user can select the weeks from witch he wants an avarage.
But i have now clue how i should do the rest. I need help in writing a macro / formula that counts the avarage of cell´s I4 in user selected sheets (choices of the user are in listbox1 on the userform). Listbox1 lists the worksheets in the worksheet that the user wants to count the avarage. The results should go to a new workbook.
I hope you can understand what i´m trying to do from my explanation.
I would appreciate any help i could get.
Bookmarks