+ Reply to Thread
Results 1 to 2 of 2

Create an updating snapshot of a worksheet on a summary page

Hybrid View

  1. #1
    Registered User
    Join Date
    03-31-2012
    Location
    Swindon
    MS-Off Ver
    Excel 2010
    Posts
    9

    Create an updating snapshot of a worksheet on a summary page

    I have created a spreadsheet, with a page for each day of the week. I have created a summary page and would like this to feature an updating snapshot of each day on the whole page. Is this possible and how would I go about it.

    Thanks,
    Dan

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: Create an updating snapshot of a worksheet on a summary page

    There is a camera tool that is not visible in the menu normally. Go to customise ribon, select "all commands" and find the camera. Add it to the quicklaunch menu.

    Now highlight the cells on the source page you want to copy. click the camera button, then click in the sheet where you want the update. This will put an updating picture of the source sheet.

    Repeat for the other sheets

+ 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