+ Reply to Thread
Results 1 to 3 of 3

Populate summary sheet (insert & index rows from info in columns on another sheet)

  1. #1
    Registered User
    Join Date
    07-26-2011
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    14

    Populate summary sheet (insert & index rows from info in columns on another sheet)

    You will have to forgive any ignorance because, I am not a programmer. Here is what I need...

    I have a large spreadsheet that lists scholarship funds for college students. Each fund has one row but, many columns. The columns contain the budget information, student info (for up to 25 students) and donor info (for up to 25 donors). It is a bit clunky but, we set it up that was so we could use it for mail merges. However, it is too large to quickly look at, print or determine quickly which scholarship has available funds. Therefore we need a summary sheet.

    The summary sheet needs to list student and money info only (no donor info) but, each student needs to have their own row (transpose?). This means the funds may need to be listed more than once if more than one student has been awarded money from that fund.

    I have included a smaller scale (10 funds) workbook that displays how we currently have the large spreadsheet (named ALL) and how I would like to see the summary sheet (named SUMMARY).

    Any help would be greatly appreciated!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    07-26-2011
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Populate summary sheet (insert & index rows from info in columns on another sheet

    Any suggestions??? Please.
    Last edited by DerbysGal; 08-03-2011 at 01:47 PM.

  3. #3
    Registered User
    Join Date
    07-26-2011
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Populate summary sheet (insert & index rows from info in columns on another sheet

    I could really use some help on this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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