+ Reply to Thread
Results 1 to 4 of 4

Mutliple tables on 1 sheet

  1. #1
    Registered User
    Join Date
    09-04-2013
    Location
    United States, Utah
    MS-Off Ver
    Excel 2010
    Posts
    6

    Mutliple tables on 1 sheet

    This may be way over my head so I thought I would see if there is a simple way of doing this.

    I have attached what I am trying to do. The first summary page shows what I want it to look like but I would like all the cells to be editable. Currently all I am doing is copying and pasting it as a picture. But I need the format to remain the same with the same table sizing.

    Hopefully that makes sense
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,618

    Re: Mutliple tables on 1 sheet

    One quick solution is to use the CAMERA TOOL as seen on the right of the summary sheet. Any changes you make to the tables show in the summary
    Attached Files Attached Files
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    09-04-2013
    Location
    United States, Utah
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Mutliple tables on 1 sheet

    I am looking for a more permanent solution I was hoping there was a way to create an additional table directly on the sheet

  4. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Mutliple tables on 1 sheet

    If you can't find the CAMERA TOOL, it is in the Quick Access Toolbar (QAT).
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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. Replies: 3
    Last Post: 12-15-2015, 05:04 PM
  2. [SOLVED] Refresh pivot tables - "Error: Cannot update PT on protect sheet" (sheet not protexted)
    By BartSeli in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-15-2013, 11:13 AM
  3. Replies: 1
    Last Post: 04-15-2013, 05:16 PM
  4. [SOLVED] Dynamic table in a different sheet from multiple tables in other sheet
    By David Brown in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-27-2013, 12:22 AM
  5. Search worksheet based on mutliple cell values on another sheet.
    By milson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2013, 12:41 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