Excel - Copy and append Data
 

Have a problem with a report that I use as data comes out automatically
via a query. I want to be able to record additional data about
entries, but if any data is removed from the system the information
that I've captured is lost/moved.

Therefore, I would like help on doing the following.
Where any entry exists in Column E (Row 2), copy all columns (E-I) to a
new sheet (Sheet2):
- If the entry within column E already exists in Sheet 2 (Column B)
overwrite with this data (From Column B onwards), OR
- If the entry doesn't exist append after the last entry in Column B.

Hope this makes sense, appreciate your help - Al.