Turn on the macro recorder whilst doing the steps.

See what you get then post back with more questions.


Gord Dibben Microsoft Excel MVP

On Fri, 12 Aug 2011 21:44:43 +1000, Mas wrote:

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.