+ Reply to Thread
Results 1 to 2 of 2

Create a reference formula

Hybrid View

  1. #1
    Registered User
    Join Date
    03-26-2022
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    1

    Create a reference formula

    Hi,
    I have a workbook as attached. It has 3 worksheets. On open the workbook some of cells on sheet "input" with values in a curly bracket (e.g. cell D6, D12). Then after hit Ctlr+Alt+F9 the cell values are populated with intended values. I just want to know how to create a worksheet as sheet "input" and force combined keys to populate data.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,937

    Re: Create a reference formula

    Hi, welcome to the forum.
    I do not use 365 but my idea would be to add a userform where with the fileds that need input and use this to pouplate the necessary cells.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-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. Use CONCATENATE to create a reference formula
    By hjbarazi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-19-2019, 11:16 AM
  2. Create reference formula from text
    By devil1980 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2008, 12:00 PM
  3. Using a formula to create named range reference
    By rgb65@bellsouth.net in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  4. Using a formula to create named range reference
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-06-2005, 04:05 AM
  5. Using a formula to create named range reference
    By rgb65@bellsouth.net in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM
  6. Using a formula to create named range reference
    By rgb65@bellsouth.net in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. [SOLVED] Using a formula to create named range reference
    By rgb65@bellsouth.net in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-29-2005, 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