Hello all and thank in advance for your patience!!!

Please bare with me whilst I try and explain what I am trying to do.

I am trying to write some code that will add data from a worksheet to
two different workbooks.

The 'data entry' workbook will have the following fields:
Date Ref no Issued to Issued by Checked by

If possible I would like the data entered under each of these fields
to:

1. a workbook called 'aerial survey data'. For this I would like the
data to be added and stored to the next blank row.

2. a workbook called 'report data'. This workbook will be linked to a
Word document and the data will be used to automatically enter report
details in the Word document. Each time the code is run in Excel I
would like the data in this workbook to be overwritten.

I plan to run the code by assigning the macro a shortcut key.

Once the data has been entered (i.e. the shortcuy key pressed and the
code run) it would be good if the data was cleared from the data entry
workbook.

I have tried to create my own code using various websites (for example
http://www.meadinkent.co.uk/xl-update-list.htm) but cannot make this
work. Is there some kind soul out there who can help me with or write
the code for me.

Many, many thanks

Paul