+ Reply to Thread
Results 1 to 3 of 3

attendances file. copy multiple cells from many sheets to one main sheet. NOOB :/

  1. #1
    Registered User
    Join Date
    02-06-2013
    Location
    new york
    MS-Off Ver
    Excel 2010
    Posts
    2

    Unhappy attendances file. copy multiple cells from many sheets to one main sheet. NOOB :/

    ok so I'll try to explain this as well as I can. I have an attendance file w/least 30 sheets. 29 of the sheets are for each separate group. The other sheet is the main one where I need to collect information like "total participants in attendance" and "total members in group" Then I divide those two and get the percentage of attendance.

    The sheets containing the individual groups info are set up like this... (1=they were in attendance)

    GROUP 1
    Name / January / February / March/
    Jess________1________0________1
    Ryan_______1________1________0
    Joe ________1________0________0
    ----------------------------------
    total P ____3________1_________1
    members___3________3_________3
    % _______100_______33________33


    The main sheet looks like this

    Group / Jan. Participation / Jan. Member total/
    Grp 1 ________3_____________3
    Grp 2 ________8_____________10
    Grp 3 ________7_____________10
    ---------------------------------------------
    _____________18____________23
    % total-__________________78.2%


    MY QUESTION-
    I know I can manually go through and link the sums of participation and total group size into the main sheet, but I have a lot of workgroups and need to do this every month, is there an easier way? I am willing to change the set up of the sheets.

    THANKS!

    _____________

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: attendances file. copy multiple cells from many sheets to one main sheet. NOOB :/

    Do you have a sample workbook?
    ==============================
    You can sum vertically between sheets (z axis)

    For example: If you wanted to sum cell A1 between Sheets 2 and 10, you could use this formula
    =SUM(Sheet2:Sheet10!A1)
    Click on star (*) below if this helps

  3. #3
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: attendances file. copy multiple cells from many sheets to one main sheet. NOOB :/

    Do you have a sample workbook?
    ==============================
    You can sum vertically between sheets (z axis)

    For example: If you wanted to sum cell A1 between Sheets 2 and 10, you could use this formula
    =SUM(Sheet2:Sheet10!A1)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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