Integrate data from one spreadsheet to another in another format

[Rubanski]

This a tricky one and exceeds my current knowledge of Excel VBA. So your help is definitely welcome! I consider it a challenge, please oppose if not the case.


I have 2 spreadsheets, both containing an overview of contracts but in 2 different formats.
The first one is grouped per client and the other one looks at the unique combination of client x contract. In my first excel 1 = contract present, 0 =no contract. For example, I have in the first row Client 1 who has contract X, Y and Z. In my overview database, I want this to show as 3 different rows, Client 1 x Contract X, Client 1 x Contract Y, client 1 x contract Z. All of them with a different unique key.

If I would change from a zero to a 1, I want that the code adds a row in my other sheet. Also the possibility of adding a client with some contracts and it showing up in the uniquekey sheet is the purpose.

Is this possible?


Many many thanks in advance! Sorry, for the bad visuals, but could'nt add an attachment.

Sprea-dsheet 1: [
................ Contract X --Contract Y ----Contract Z-------Contract AA------Contract BB
Client 1 --------1 ----------1 ------------- 1 ---------------- 0-----------------0
Client 2 ---------0-----------0----------------0-----------------0-----------------0
Client 3 --------0-----------0 ---------------1------------------0-----------------0




Spreadsheet 2

Unique key---------Client ------Contract
1----------------------1----------Contract X
2----------------------1----------Contract Y
3----------------------1----------Contract Z
4----------------------2----------Contract AA
5----------------------2----------Contract BB
6----------------------3----------Contract Z

[/SIZE]