+ Reply to Thread
Results 1 to 3 of 3

Mirroring Cell Contents.

  1. #1
    Registered User
    Join Date
    02-24-2010
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question Mirroring Cell Contents.

    Hello,
    I am currently using Excel 2003, but have access to 2010.
    I require a workbook with multiple sheets (31) so that it can be printed month at a time.
    Within the top 4 rows, which are to be repeated on each page on each sheet, is a date which increase sequentially (per sheet).
    Under these 4 rows the data needs to be exactly the same as on the first page.
    I am currently using the "=A5" formula with formatting, but the issue arises when adding in new rows below the ones already present.
    I have attched the workbook, which is protected but with no password.
    What is the best way of achieving this?
    Sincere regards,
    Ryan

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Mirroring Cell Contents.

    Try using the below in A5 of subsequent sheets

    =INDIRECT("Day1!"&ADDRESS(ROW(),COLUMN()))
    or
    =INDIRECT("Day1!A5")

    It will always show results in Cell A5 of Day1 sheet
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    02-24-2010
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Mirroring Cell Contents.

    Hi @Ace_XL, and thanks for your quick reply.
    Unfortunately this does not work how I want - I also need formatting copied over.
    I have experimented with the "Camera" button, but even if the cells on "Day1" are blank, the Camera image still adds them to the corresponding sheet, which is not what I want.
    I want to be able to have rows 1 through 4 repeated at the top of each page, independant for each sheet. I want all the cells below Day1 Rows 1-4 to be exactly the same as on Day1, including formatting.
    Is there a way to do this?
    Sincere regards,
    Ryan

+ 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