I am trying to copy a column into another sheet of the same file. I want it to work in such a way that when I make changes to this column in sheet 1, these changes appear in sheet 2. I know how to transpose data. But I don't want to alter the column into a row. I want to keep it as a column when I move it to the new sheet.