VBA Search and copy (2 Workbooks involved)

[longstick]

I am looking to automate some updating that I do.

I will try my best to explain.

Book1:

Serial#	Cycle Count	Date	Complete
A4646366	525200	06/06/13	Done
D2352352	235500	07/06/13
GC1223	667200	08/06/13

<tbody>
</tbody>

Book2:

Serial #						Life Cycle Count	Last Updated
F523523						1000000
G235252						2000000
D2352352						50000
A4646366						500000
GC1223						250000

<tbody>
</tbody>

1. Search down the "Complete" column (Column D) to find the next empty cell (Row 3).
2. Check to see if the cell to the left has data. (is there new data that needs to be updated?).
3. Search the serial number from "Book1". Find it in "Book2".
4. Add the Cycle count of the serial number in "Book1" to the Life Cycle count in "Book2"
5. Update the "Last Update" in "Book2" with the date in "Book1"
6. If successful then place "Done" in blank cell found in step 1. If unsuccessful (example: Serial number not found in step 3) then place "Updating Error" in the cell.
6. Repeat until there is no more data in "Column C"


I hope I've explained what I would like.

Could you also place 'notes in the macro explaining what they lines do. I'm trying my best to learn.

Thank you,