Compare information and extract if changed

[bertrand82]

Hi,

Each month I extract some information from a system into a excel sheet which the following columns:

Idnumber (unique)
Name
Place of service
Employment type
Company

The next month I do the same but now I also need to clarify changes in a seperate sheet.

Is there a possiblilty to compare the columns from the two sheets and in some way clarify if someone has changed name, place of service and so on?

Br Bertrand

[arlu1201]

Yes its possible.

Please attach a sample and i can help you.

[bertrand82]

Hi Arlett,

I found a solution.

thanks anyway

[arlu1201]

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[bertrand82]

You are right, im sorry,

I found my solution via youtube:

http://www.youtube.com/watch?v=ZE-Sd4C2Gcs

Br Bertrand