AndrewTrevayne
New Member
- Joined
- Jul 27, 2013
- Messages
- 8
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.
My files are:
Source = C:\Temp\Input.xls
Target = C:\Temp\Target.xls
On the Input.xls
<tbody>
</tbody>
On the Target.xls
<tbody>
</tbody>
On this example, I'd like to insert the entry on the Input.xls to the last record of Target.xls
Can this be done? Would really appreciate any help. Thanks in advance.
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.
My files are:
Source = C:\Temp\Input.xls
Target = C:\Temp\Target.xls
On the Input.xls
| Heading | Heading |
| Name | Bruce Wayne |
| Address | Gotham city |
| Telephone | 666666666 |
| SUBMIT BUTTON |
<tbody>
</tbody>
On the Target.xls
| Name | Address | Telephone |
| Clark Kent | Smallville | 999999999 |
| Oliver Queen | Starcity | 888888888 |
<tbody>
</tbody>
On this example, I'd like to insert the entry on the Input.xls to the last record of Target.xls
Can this be done? Would really appreciate any help. Thanks in advance.
