Okay so I have two files. One is filled with data the other is empty. For certain reasons I want to copy/mirror columns and bring it over to the empty sheet in different column orders.
I'm doing this so I can simply reorganize columns and clean it up on the second empty file.
So again I need to basically reference columns on file 1 and bring it over to the empty file 2.
I know there's a way to do it, something with external references, can anyone help me with a way to do this?
I have a example Screenshot showing an example of what I want attached: