![]() Furthermore, we separate it into file name, sheet name and cell reference. Now we wrap the INDIRECT formula around this path.Instead of pasting it normally, click on “Link” in the bottom left corner of the Paste Special window. Paste it into your main file using paste special (Ctrl + Alt + v ).The INDIRECT formula has only one argument: The link to another cell which can also be located within another workbook. Let’s take a closer look at how to build the formula. ![]() ![]() Only condition: the source file must be open in the background. With the INDIRECT formula you can link to other files.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |