Skip to content
TheChatArchiveThe Chat Archive
Geminigemini-2.5-flash-preview-04-17· GoogleHugging Face LMArena Human Preference 140K

HOW TO MAKE A PROGRAME IN EXCESS THAT IF I PUT A NUMBER THE VALUE OF THE NUMBER WHICH I…

From a Chatbot Arena battleThe same person sent this prompt to two anonymous models at once. Compare it with Mistralmistral-medium-2505’s answer.
  1. User

    HOW TO MAKE A PROGRAME IN EXCESS THAT IF I PUT A NUMBER THE VALUE OF THE NUMBER WHICH I ENTERED IN NEXT SHEET SHOW UP

  2. Gemini Assistant

    Okay, you want to link a cell in one Excel sheet to a cell in another sheet so that whatever number (or text) you type in the first cell automatically appears in the second cell.

    This is very easy to do using a simple formula in Excel. You don't need a complex "program" (like VBA macros) for this.

    Here's how to do it step-by-step:

    Let's say:

    • You enter the number in Sheet1, cell A1.
    • You want the number to show up in Sheet2, cell A1 (you can choose any sheet and cell).

    Steps:

    1. Go to the destination sheet: Click on the tab for the sheet where you want the number to appear. In our example, this is Sheet2.
    2. Select the destination cell: Click on the cell where you want the number to show up. In our example, this is A1 on Sheet2.
    3. Start typing the formula: Type an equals sign = in the selected cell. This tells Excel you are entering a formula. =
    4. Reference the source sheet and cell (the easiest way):
      • While still typing the formula (after the =), click on the tab for the sheet where you enter the number (in our example, Sheet1).
      • Click on the specific cell where you enter the number (in our example, cell A1 on Sheet1).
      • You will see Excel automatically build the reference in the formula bar, something like: =Sheet1!A1
    5. Press Enter: Press the Enter key on your keyboard.

    That's it!

    Now, go back to Sheet1 and type a number (or anything else) into cell A1. When you press Enter, immediately switch to Sheet2, and you will see the same number automatically appear in cell A1 on that sheet.

    Explanation of the Formula:

    • = : Starts the formula.
    • Sheet1! : Refers to the sheet named "Sheet1". The exclamation mark ! separates the sheet name from the cell reference.
    • A1 : Refers to cell A1 on that sheet.

    So, =Sheet1!A1 simply means "Show me whatever value is currently in cell A1 on Sheet1".

    Things to Note:

    • Sheet Names: If your sheet name has spaces (like "My Data"), Excel will automatically put single quotes around it when you click on it (e.g., ='My Data'!A1).
    • Empty Cell: If the source cell (Sheet1!A1) is empty, the destination cell (Sheet2!A1) will usually show 0.
    • Text: If you type text in the source cell, the text will appear in the destination cell.

    This method creates a live link between the two cells. Whenever the value in the source cell changes, the value in the destination cell updates automatically.

Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.