Add data from a template exel file into a master excel database [Closed]

Report
Posts
1
Registration date
Saturday June 6, 2015
Status
Member
Last seen
June 6, 2015
-
Hi,
I Have basically a template which I use for export, as shown in example below
My template columns A,B,C layout are like:

A B C
----------------------------------------------------
Xp Ref 1
date 1/1/2015

ITEM1 10 100
ITEM2 10 200
ITEM3 10 300

Imagine the above is my first export order, now I need a macro which I would run so that it copies this data into a master database excel file , This database columns A ,B,C,D,E should have the data as below

A B C D E
---------------------------------------------------------------------------
1 1/1/2015 ITEM1 10 100
1 1/1/2015 ITEM2 10 100
1 1/1/2015 ITEM3 10 100

So next time I have new export, Xp Ref will be 2 with new date and items, which then when I save the new file and run macro, the data from the second export up to the last row in it will be added to the master database file right below the last order and so on.
I hope I explained this well and thank you very much for the help.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!