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 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 >Windows("a

$$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 W