Re: $$Excel-Macros$$ Re: how to copy 1 file column to another file column automatically

Thanks you sir, i will try to do it On Mon, Jul 12, 2010 at 12:45 PM, George use...@ccx-grads.org wrote: Hi Ankit, You can run this code and enjoy. Sub Macro1() Columns(A:A).Select Selection.Copy Windows(as.xls).Activate Columns(B:B).Select ActiveSheet.Paste

$$Excel-Macros$$ Re: how to copy 1 file column to another file column automatically

Hi Ankit, You can run this code and enjoy. Sub Macro1() Columns(A:A).Select Selection.Copy Windows(as.xls).Activate Columns(B:B).Select ActiveSheet.Paste Windows(a.xls).Activate Columns(C:C).Select Application.CutCopyMode = False Selection.Copy