+ Reply to Thread
Results 1 to 2 of 2

Linking Cell Contents

  1. #1
    Registered User
    Join Date
    06-11-2012
    Location
    San Francisco, CA
    MS-Off Ver
    Excel 2010
    Posts
    24

    Linking Cell Contents

    I have a spreadsheet in which every column updates relative to the contents of another worksheet. Several of my columns are intended to allow for a user to manually enter data that will override the contents of adjacent cells. Unfortunately, because the data on this sheet is ever changing, maintaining the relative position of any information manually imput (i.e. the manual overrides entered by users) seems to be impossible.

    Is there a method by which to link manually entered data to existing data so that when the existing data changes locations, the manually entered data automatically follows the relative existing data.

    Thanks in advance.

    -Mike

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    31,115

    Re: Linking Cell Contents

    Assuming there's some key field or combination of fields that make a unique reference, you could, perhaps use VLOOKUP or INDEX/MATCH

    Being realistic, it's no easy task to manage links between two spreadsheets that are both maintained manually.

    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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