Hi,

I'm trying to copy information systematically using a formula or VBA code across different sheets in the same workbook. Yes, I could just copy and past from one workbook to the other but I have to do this many times a day with different workbooks and am hopeful to find an easier way to solve this.

For example I'm trying to copy values from one column in sheet 2 named XYZ into sheet 1 column named ABC_XYZ (this column location can change).
I'm trying to only copy the values and text, and not the column headings.

I've been trying different things for days and hope that there is an easy answer for this.
I've got nothing left to try, and hoping that you guys can help!

Best,
GJK