Results 1 to 9 of 9

How Do I Override a Value In the Following Situation

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2019
    Location
    Miami, Florida
    MS-Off Ver
    2016
    Posts
    73

    How Do I Override a Value In the Following Situation

    I don't know how to give a proper description to this problem. Attached is a workbook I created. The ask is when the client receives the workbook, they need to be able to enter in a hardcoded number in sheet "Client" cells B2:B3. When they enter a number into B2:B3, the values on sheet "Employee" cells B2:B3 need to update to these hardcoded values. The issue is that cells B2:B3 in "Client" rely on cells B2:B3 in "Employee." The client cannot touch the "Employee" sheet whatsoever. I was also told I am not allowed to create another sheet that will be hidden and it all needs to come from these two sheets. Any idea?
    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. Help with an if/then situation
    By Lamont15 in forum Excel General
    Replies: 3
    Last Post: 07-15-2018, 04:59 PM
  2. Need Help in this situation
    By AOG_excel in forum Excel General
    Replies: 4
    Last Post: 07-26-2016, 03:49 AM
  3. Using EVALUATE - is this the right situation?
    By m1notaur in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-13-2016, 04:18 PM
  4. #N/A situation
    By bnwash in forum Excel General
    Replies: 5
    Last Post: 07-18-2007, 04:03 AM
  5. Can I use this situation?
    By tonyrice in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-22-2007, 12:57 PM
  6. Nested IF in this situation
    By Cossminnn in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-20-2006, 06:50 AM
  7. need help with a If=then situation.
    By FireBrick in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-02-2005, 11:06 AM

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