Hi,

I have two sheets in my spreadsheet, the first which is 'an input
form' and the second which contains all of the data records.

The first sheet ("Input") contains the following titles:

A5 Case ID
B5 Date
C5 Resolver
D5 Details
E5 Resolution
F5 Notes

I need to transfer this data to sheet "Data". These titles all exist
within the Data Sheet on Row 1.

Therefore need a macro to do the following:
1) Check if A6 exists within sheet "Data", column A - If so, end
procedure with message "Record already exists")
2) If the outcome of 1 is that the record doesn't exist, the code
needs to copy A6:F6 from sheet "Input" to sheet "Data" and offset from
Row1 until the next empty row exists.

Appreciate your help as stuck on this and can find similar requests on
the newsgroups but not close enough to what I need.

Thanks in advance, Al.