+ Reply to Thread
Results 1 to 2 of 2

Linking cells globally to allow users the ability to change cells on separate sheet/cells.

  1. #1
    Registered User
    Join Date
    01-14-2014
    Location
    Somewhere, Canada
    MS-Off Ver
    Excel 2010
    Posts
    11

    Linking cells globally to allow users the ability to change cells on separate sheet/cells.

    I have a workbook that uses the values that a user had entered into 3 cells to calculate multiple other charts/diagrams on multiple sheets within the workbook. Each sheet would show what the user had entered in the 3 cells to allow them to see what is being used to calculate each table. Is it possible to link these cells so that the user can change the 3 values without having to go back to where he originally entered the 3 values?

    For example, a user has entered in 3 values in Sheet 1. A formula in Sheet 2 displays what is entered by the user and uses these calls in Sheet 2 for calculations. When the user wants to change the three values, he would have to navigate to Sheet 1 and enter in the new values to have the workbook recalculate all the tables. Is there a way to link the three cells from Sheet 1 and Sheet 2 so when the user is on Sheet 2, he has the opportunity to change the values on the current Sheet without having to navigate to Sheet 1 to do so?

  2. #2
    Registered User
    Join Date
    01-14-2014
    Location
    Somewhere, Canada
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Linking cells globally to allow users the ability to change cells on separate sheet/ce

    I solved this by simply creating a hyperlink to the cell I want the user to be redirected to.

+ 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. [SOLVED] Linking cells from one sheet to another and update cells accordingly based on selection
    By hcyeap in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-17-2013, 09:53 AM
  2. copy a range of cells N times and paste in separate sheet and also change a specific colum
    By maramkarthik in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-21-2013, 04:27 AM
  3. Replies: 1
    Last Post: 07-25-2007, 04:02 PM
  4. [SOLVED] Change scales from reference cells value for a chart in a separate sheet
    By ers in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-02-2006, 02:10 PM
  5. Linking cells with a diffrent sheet with 2 cells
    By Angelofdoom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-15-2006, 12:20 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