A cell in a Source Sheet and link to Mutiple cells in a Destination Sheet

Teresa Lai

In my destination sheet, I want to link the values of a specific range of cells to A CELL in the source sheet. Is there quicker way to do the linkage? I tried to copy paste the format but the link does not apply to the rest of the cells.

Darren Mullen

@Teresa Lai Are you trying to combine the values in the range of cells into one cell? Or... trying to put the value from one cell into multiple cells?