How to transfer data from one worksheet to another

[excel_199]

if the data is protected, with a password, and I have to return the exact same column to another worksheet what is the best way to do this ? not copy and paste, it does not give me the same output.

 

[alansidman]

not copy and paste, it does not give me the same output.

Is this because the data being copied is actually a formula and not data? If this is the case and you are looking to move it as data, then copy--->paste special--->values.