Bulk import. (Copy Data from one sheet to a main sheet with conditions)

Can someone help with this?

I have a Spreadsheet called "ALL" which stores employee codes, ID's, Names, and additional details (One Row per employee)

My aim is to create the ability to 'bulk' insert into this sheet, with new data (new employees) but there needs to be a search condition which searches the sheet to make sure that the new data does not have any duplicates. If there are duplicates in Employee codes then only the other information is in the ROW is changed.

If I need to be more specific, please let me know.

Thanks
Daniel

Can you post a spreadsheet with an example of the data?
What column are the employee codes in? Where is the new data coming from? As an example, if the employee codes are in Row A you could probably use:

Please Login or Register  to view this content.

to find if the code exists and return the appropriate row.

Sorry about the late reply.

I have decided to not go with the bulk insert idea.
I am manually checking before copying them into my database. It will only be a 'one off'.

Thanks for the code help

Sorry about the late reply.

I have decided to not go with the bulk insert idea.
I am manually checking before copying them into my database. It will only be a 'one off'.

Thanks for the code help