Count cell avarage from selected sheets

[peterkiukas]

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.

[ravishankar]

Hi
Try the following codes

Please Login or Register  to view this content.

The user can choose the row nos that correspond to the weeks

Please Login or Register  to view this content.

Ravi

[peterkiukas]

Thank you for your reply!

I´ll try it when i get back to work and let you know how it worked.

[peterkiukas]

I just tried the codes you posted, but i could not get them to work. The problem might be with the user :=). I Quess i hafty think of some other approach to this problem, Because i´m at a dead end witt this. But still
i am very thankfull of your help.