Using excel macros can be really helpful in finding the external reference links. Cells C1 through C4 on “Sheet1” now contain the array formula “” surrounded by curly brackets, and show the same data as the precedent cells in “Sheet2. Method 3: Find External Reference links by using Excel Macro. In this example, type “=Sheet2!A1:A4” and press “Ctrl,” “Shift” and “Enter” simultaneously. Each dependent cell is now linked to the cell in the precedent range that’s in the same respective location within the range. Press “Ctrl,” “Shift” and “Enter” simultaneously to complete the array formula.
Type “=,” the worksheet name containing the precedent cells, “!,” the top left cell of the precedent range, “:” and the bottom right cell of the precedent range. Click and hold on cell C1, drag the mouse to cell C4 and release the mouse to highlight the range. In this example, assume you want to link cells C1 through C4 to the precedent range. Click and hold the mouse button on the top left cell of the range, drag the mouse cursor to the bottom right cell in the range and release the mouse button to select the range. This range must be the same size as the precedent range, but can be in a different location on the worksheet. Select the range of blank cells you want to link to the precedent cells. This precedent range is one column wide by four rows high.Ĭlick the worksheet tab at the bottom of the screen that contains the blank cells in which you will insert a link. In this example, assume cells A1 through A4 on “Sheet2” contain a list of numbers 1, 2, 3 and 4, respectively, which will be your precedent cells. For example, assume you want to link a range of blank cells in “Sheet1” to a range of precedent cells in “Sheet2.” Click the “Sheet2” tab.ĭetermine the precedent range’s width in columns and height in rows. A range is a block or group of adjacent cells. To Link Multiple Cells in Excel From Another Worksheet :Ĭlick the worksheet tab at the bottom of the screen that contains a range of precedent cells to which you want to link. From this point forward, anything you type in A1 will show up in C1 as well. Then I have a book, where each page has multiple cells relating to a line item on the inventory sheet. If you want the contents of, say, C1 to mirror the contents of cell A1, you just need to set the formula in C1 to =A1.
0 kommentar(er)
