Have a tricky one i think... at least for me.... I enjoy the challenge
of excel and vba but never know how to start things off...

Here is what I would like in a perfect world:

A macro that is triggered when workbook "LIST" is saved.

First message box. Do you want to transfer? If no, just save. If yes
THEN.....

Open new workbook based on template TRANSFER.
Search column H in LIST for rows with most recent date.
Extract information froms those rows, but only info found i columns A,
G and H and place in new workbook on first available rows into
columns A, B and C.

Does this make sense? Is it really hard? Can anyone help me?

Would really appreciate any scrap of help...