Is there any way to use formulas and linked at the same time? I want a column to add data from the columns A + B + C to = ABC and then have ABC show up on a different tab. Is that possible?
This is helpful thanks! But does it require linking each of these rows by hand? Excel allows for instant mirroring of data. If you want the data to be pulled from a cell one only needs to write "=A1" and then all the data from A1 will show up whereve...