+ Reply to Thread
Results 1 to 9 of 9

need help in creating a summary page

  1. #1
    Registered User
    Join Date
    08-18-2015
    Location
    Louisiana, USA
    MS-Off Ver
    excel 2007
    Posts
    10

    need help in creating a summary page

    fim log.xlsx
    I am just a basic user for excel and I have multiple work sheets that is formatted the same way and I would like to get the data on cells AK9:AO30 transferred to a summary page. Is there a way on doing this? Thanks.

  2. #2
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: need help in creating a summary page

    Enter sheet name above table
    and change formula (red field) to match that cell.

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    It should work for every sheet.
    Attached Files Attached Files

  3. #3
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,404

    Re: need help in creating a summary page

    So formula in H12 should be:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then extend it to the right and down to fill the table.

    And so on for other tables.

  4. #4
    Registered User
    Join Date
    08-18-2015
    Location
    Louisiana, USA
    MS-Off Ver
    excel 2007
    Posts
    10

    Re: need help in creating a summary page

    thanks zbor. I'll try the given solution on my main work sheet. It looks like it will work.

  5. #5
    Registered User
    Join Date
    08-18-2015
    Location
    Louisiana, USA
    MS-Off Ver
    excel 2007
    Posts
    10

    Re: need help in creating a summary page

    If I wanted to have a printable summary page, does the positioning of the table affect the formula you gave me?

  6. #6
    Registered User
    Join Date
    08-18-2015
    Location
    Louisiana, USA
    MS-Off Ver
    excel 2007
    Posts
    10

    Re: need help in creating a summary page

    I tried the formula but it didn't come out right.. can you help me figure out what I did wrong?
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    08-18-2015
    Location
    Louisiana, USA
    MS-Off Ver
    excel 2007
    Posts
    10

    Re: need help in creating a summary page

    FIM update LOG.xlsx

    oops wrong file sent.

  8. #8
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,518

    Re: need help in creating a summary page

    Your last file is empty: no formulae is SUMMARY so unable to determine problem.

    Did you have tab name in B8? G8? not H!

  9. #9
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,518

    Re: need help in creating a summary page

    =INDIRECT("'"&$J$9&"'!"&ADDRESS(11+ROWS($B$12:$B12),36+COLUMNS($B$12:B$12)))

    Column numbers are changed when you copy: they need to remain as shown.

+ 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. Creating a summary page
    By Zigi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-25-2013, 01:30 AM
  2. Creating summary page from Pivot Table
    By ScottBeatty in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-26-2013, 06:11 PM
  3. Creating a Summary page
    By 3PDM in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-12-2012, 03:36 PM
  4. [SOLVED] Creating a summary page from multiple worksheets
    By abbysawisch in forum Excel General
    Replies: 7
    Last Post: 06-19-2012, 09:45 AM
  5. Creating a summary page in excel
    By zrupnick in forum Excel General
    Replies: 2
    Last Post: 09-27-2009, 08:14 PM
  6. Creating a dynamic summary page
    By johnny V in forum Excel General
    Replies: 3
    Last Post: 05-08-2008, 08:55 AM
  7. Creating a summary page in Excel
    By Tom in forum Excel General
    Replies: 1
    Last Post: 04-18-2006, 04:00 PM
  8. [SOLVED] Creating a summary Page
    By Newbie81 via OfficeKB.com in forum Excel General
    Replies: 4
    Last Post: 01-06-2006, 08:00 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