Append Cell Content to a New Line in another Workbook

[Andrew.Trevayne]

Hi everyone,
I was hoping if anyone could help me.
I am trying to figure out a vba that can append data input from one of my Excel Workbook into a new line of another Workbook.
Basically I have 2 Excel documents, the 1st one is where I key-in the data. The 2nd one is where I want these data to be recorded.
I tried recording a Macro however instead of adding a new line for each new record, it just overwrites the previous entry on the target workbook.

I have attached the 2 Excel Files, I am storing these 2 documents on "C:\Temp" location on my hard drive.
Would really appreciate any help. Thanks in advance.

[apo]

Hi..

This should do what you want.. Just change "D:\Target" to wherever your Target workbook is located at.

Code to copy to Target sheet..

Please Login or Register  to view this content.

Code to clear the fields..

Please Login or Register  to view this content.

[apo]

btw. fyi.. if you cross post.. you should display ALL places that you ave cross posted.. there are many valid reasons for this rule..

http://www.mrexcel.com/forum/excel-q...-workbook.html