Hi,

I have data in a database (list of PC, servers, ...) where it is being up-to-date by the helpdesk people.
I have an Excel which has extra (financial) information on those assets which I can't put in the database.

I wan't to update the Excel list with the data from the database without losing the extra information that is already in the Excel.

I need to see that there are assets who aren't in the database anymore or are new in the databse but not yet in the Excel.

I can export the data in the database to Excel (there's no problem with accessing the data, but i have with merging it.

An (simplified) example of the Excel list is this

Server1 $3000 active
Server2 $3500 active
Server3 $3500 active

The data in the database is this

Server2
Server3
Server4

And I would have something like this

Server1 $3000 inactive
Server2 $3500 active
Server3 $3500 active
Server4 new

How can I do this?

thanks in advance

Patrick