+ Reply to Thread
Results 1 to 2 of 2

Linking cell values for multiple cells from one singular cell

  1. #1
    Registered User
    Join Date
    03-16-2017
    Location
    Naples, FL
    MS-Off Ver
    2010
    Posts
    1

    Linking cell values for multiple cells from one singular cell

    Hi,

    I have used excel for a while and can do basic functions with data and formulas, but I am struggling with trying to save a lot of time with figuring out how to do a certain function or table.

    For example, lets say I have 50 separate data entries with different colors. So lets just say in column A, I have different colors, and in column B I have a corresponding number. For example:
    A B
    Red 17
    Blue 20
    Green 4
    Yellow 7

    Now lets say I have 50 different entries like this, and the values from column B change often. Is there a way to have a master list of colors and entries and have them linked to the entries on a separate page, where I could change the numbers on the master list and they would change automatically on the entries?

    Thanks,

    Chris

  2. #2
    Valued Forum Contributor
    Join Date
    08-06-2013
    Location
    Detroit, Michigan
    MS-Off Ver
    Excel 2013
    Posts
    671

    Re: Linking cell values for multiple cells from one singular cell

    Yes, Create a new worksheet "Master List" with Color in A and Number in B, then in B2 on your normal sheet enter:

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    1. Include a sample workbook with an example of the result you want
    2. Use [CODE] and [FORMULA] wrappers for your VBA code or excel formulas
    3. If your question has been answered, mark the thread as SOLVED and click on the "Add Rep" star to thank whoever helped you.

+ 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. How to Create Singular/Plural Formats in FORMAT CELL option?
    By e4excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2017, 02:02 AM
  2. [SOLVED] How to make a singular macro apply to multiple cells?
    By Lowa in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-18-2015, 10:26 AM
  3. Sum values from multiple cells - multiple lookup values in single cell
    By taxdept in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-21-2012, 04:12 PM
  4. Linking several cells from 1 sheet to another using a singular reference
    By chrispygreen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-06-2011, 04:31 PM
  5. linking multiple cells to 1 cell
    By sohilbhai in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-30-2008, 06:32 AM
  6. Linking multiple cell data to a single cell
    By matt92 in forum Excel General
    Replies: 5
    Last Post: 03-14-2007, 01:54 AM
  7. Linking cells w/ values only to a referenced cell
    By Paul987 in forum Excel General
    Replies: 4
    Last Post: 09-22-2006, 03:05 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