Macro to Send line of data into another workbook checking for next available line

[craigmase]

simply put, I'm trying to create a macro VBA to copy a line of data in one work book and paste it into a central recording WB on the next empty line

This macro will be put onto a number of documents (all the same) which are audit documents that record scores. Then I click a button and it will send a compiled row of data into another workbook which compiles all audit data together

I know it should be simple but I am really stuck!

please help

 

[craigmase]

so
workbook "audit" has a tab "compile" and needs to pick up row 3 and send it to workbook "roll up" tab "data" into the next available blank row...

ideally I would want it to check column A for duplicate reference too and error if it already exists...

 

[craigmase]

please please help

 

[craigmase]

Can anyone help please??

 

[craigmase]

if anyone could help please that would be great