Hi all,

I would like advise on how I can import data from an Excel Worksheet
into an Excel Template.

For example:

Excel Workseet
Column A : Date
Column B : Customer Name
Column C : Code No#
Column D : Weight

Excel Template
Column A : Date
Column B : Year
Column C: Customer Name
Column D : Code No#
Column E : Code Color
Column F : Weight

I would like to import Column A from the Worksheet into Column A of the
template, Column B from the Worksheet to Column C of the template, etc.

How can I set up an macro button to do this for me.

Any help will be greatly appreciated.

Thanks in advance.