Forum Discussion

datagirl68's avatar
datagirl68
Copper Contributor
Mar 05, 2021
Solved

linking range of cells in one workbook to range of cells in another workbook

How do I link a range of cells in one Excel workbook with a range of cells in another workbook?   Over 3000 cells in the range   Thank you!
  • NikolinoDE's avatar
    Mar 05, 2021

    datagirl68 

     

    Create an external reference (link) to a cell range in another workbook

    (Click on header fo rmore infos)

    You can refer to the contents of cells in another workbook by creating an external reference formula. An external reference (also called a link) is a reference to a cell or range on a worksheet in another Excel workbook, or a reference to a defined name in another workbook.

     

    If this information helped you, please mark this post as "Correct answer" and on like (hand with thumbs up), so that other members can benefit from this information later.

    If the information did not help you, please ignore it.

     

    I would be happy to know if I could help.

     

    Nikolino

    I know I don't know anything (Socrates)

     

Resources