Results 1 to 8 of 8

Change formula to refer to selected sheet

Threaded View

  1. 03-09-2023, 06:19 AM #1
    josephteh
    josephteh is offline
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2019
    Posts
    4,542

    Change formula to refer to selected sheet

    In attached workbook, the formulas in cells highlighted in YELLOW refer to cells in "Company A" sheet.

    How do I change the formulas to refer to the cells in sheet named in cell D2 (highlighted in BLUE), whatever company name is selected?

    Thank you.

    Change formula to refer to selected sheet.png
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to refer to sheet in a formula by using that sheets name in a cell
    By achammar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-11-2022, 01:42 PM
  2. How to change VLOOKUP formula to refer to multiple worksheets?
    By Superhik in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-18-2019, 02:47 PM
  3. Refer to correct sheet via other cell in formula
    By ferodo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-25-2016, 11:50 AM
  4. Formula to refer to other visible sheet not static
    By coreytroy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-07-2013, 06:18 AM
  5. refer to another sheet in this formula
    By mrp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-11-2010, 08:21 AM
  6. Refer to formula in another sheet
    By Jonsson in forum Excel General
    Replies: 5
    Last Post: 12-08-2005, 09:15 AM
  7. How to refer to current sheet in a formula
    By Poxypig in forum Excel General
    Replies: 2
    Last Post: 12-05-2005, 03:55 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1