Macro to append data to a different workbook

[smarinaj]

Good afternoon,

I have to admit that I have very little experience creating macros, so I would love to get your help.

I created the following macro to do this:

1. Get data in Workseet "C" of my Test Workbook
2. Paste it into a new workbook named "WordsA.xls".

I need to do this process every day, so I would like to append the new data I enter in my "Test" workbook to the workbook named "WordsA.xls", without deleting what I already have in "WordsA.xls".

Can you please help me accomplish this? Thanks in advance.

Right now my code looks like this:

Sub CopyWorkbookA()
Dim wb As Workbook
Worksheets("A").Copy
Set wb = ActiveWorkbook
wb.SaveAs "WordsA.xls"
wb.Close
End Sub