Results 1 to 8 of 8

Excel Table Mirroring

Threaded View

  1. #1
    Registered User
    Join Date
    02-07-2014
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    3

    Question Excel Table Mirroring

    I have searched all day trying to find an answer to this question and can't find exactly what I'm looking for. I'll see if I can attach an example of what I'm trying to do.

    Sheet1 has a list of names in column A.
    I have turned that list into a table.

    Sheet2 needs to mirror that list of names, again in column A.
    To do this, I labeled cell A2 on Sheet2 =Sheet1!A2 and then proceeded to click the bottom right corner of the cell and drag down to fill the area needed to mirror the entire column of the indexed table.

    NOW... here's my predicament...

    I fill in information in the rows next to the names that are mirrored from Sheet1 on Sheet2. My problem arises when I add or delete names from Sheet1. It reflects immediately on Sheet2, which is great, but only column one moves - meaning that the information I have put next to the names on Sheet2 is now no longer next to the correct name. This also happens if I add a name to the bottom of the list on Sheet1, and then sort them A-Z.

    What I need is for the rows on Sheet2 to be locked to the first column, so when the name in the first column moves up or down, the information next to it follows it. And if I delete a name from Sheet1, I need the name on Sheet2 AND all the information next to it to also be deleted.

    Does this make sense? It sounds so easy but I can't find an answer anywhere! I'm about to pull my hair out!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mirroring a single table across worksheets
    By cnstarz in forum Excel General
    Replies: 2
    Last Post: 05-22-2011, 04:38 AM
  2. Excel Mirroring
    By thomasjackson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-20-2009, 11:45 AM
  3. [SOLVED] Mirroring observations in Excel table along diagonal
    By Arjen in forum Excel General
    Replies: 0
    Last Post: 08-01-2006, 09:20 AM
  4. Excel Mirroring Data
    By mickp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-21-2006, 01:40 AM
  5. [SOLVED] Excel should allow mirroring of multiple cells
    By Doyle_D in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-24-2005, 03:06 PM

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