+ Reply to Thread
Results 1 to 4 of 4

Count cell avarage from selected sheets

  1. #1
    Registered User
    Join Date
    11-09-2007
    Posts
    24

    Count cell avarage from selected sheets

    Hi,

    I have a raport for each week of the year (each week in a different sheet) of our companys service efficiency. Now im trying to write a macro that counts the avarage of each store or the stores the user has selected.

    Ive 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 cells 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 im trying to do from my explanation.

    I would appreciate any help i could get.
    Last edited by peterkiukas; 08-23-2008 at 06:17 AM.

  2. #2
    Forum Contributor
    Join Date
    02-27-2008
    Posts
    762

    macro

    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

  3. #3
    Registered User
    Join Date
    11-09-2007
    Posts
    24
    Thank you for your reply!

    Ill try it when i get back to work and let you know how it worked.

  4. #4
    Registered User
    Join Date
    11-09-2007
    Posts
    24
    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 im at a dead end witt this. But still
    i am very thankfull of your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. OFFSET a RANDomly selected INDEX cell?
    By Clark in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-10-2008, 05:30 PM
  2. count up to the next blank cell
    By angelperez in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-04-2008, 09:40 PM
  3. Select active cell and return value
    By mabbutt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2007, 07:14 AM
  4. Active Cell Character Count
    By JoJo in forum Excel General
    Replies: 2
    Last Post: 04-16-2007, 07:03 PM
  5. Hide sheets based on cell value input
    By EdMac in forum Excel General
    Replies: 10
    Last Post: 11-17-2006, 06:01 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1