I was wondering if it was possible to link a cell/row etc and have the column information align and not just copy how it is in a sheet.
For example, when I link the row, the email column in the destination sheet is different to where it is in the original. Is there a way for it to automatically match up?