VBA merge 2 workbook 1 workbook

[Powerblade]

Dear friends!

I have a big problem, where i tried a lot of code...

Here is the deal:

Data is from a company who has i.e. 100 employees with gsm-phone, all contracted by 1 operator and becomes 1 invoice with all 100 gsm-phone charges and specs.

I have 2 worksbooks:

1: Invoice.xls
2: userdata.xls

1: invoice has all data of gsm-phone-nr's, dates, etc etc
2: userdata has 2 info: gsm-nr and name of the corresponding person

I want 1 new workbook:

first column called nr:
autonr...: according to merged rows, 1,2,3,4 etc etc..

2. column: date invoice:
look workbook invoice and cell:F4

3. column: desciption:
look into workbook invoice column B(gsm numbers) and select only rows of column A containing :aans*
next match the found columns with
workbook userdata and output all the phonenumbers from invoice and put after the numbers, the corresponding names with the gsm-numbers like:

gsm-number, name,

after that, look to invoice cell: f5 ( date ) and put it as last you get:

gsm-number, name,date

4. coulmn phonenr:

same as 3, look into workbook invoice column B(gsm numbers) and select only rows of column A containing :aans*

5. column: Price
look into workbook invoice column L(Price) and select only rows of column A containing :aans*

invoice:

userdata:

output workbook:

http://www.gpssystem.nl/output_workbook.JPG

 

[Powerblade]

no one who can help?? please, if a part of the code working, is ok tooo...

maybe different people can help with several parts.... every suggestion is more then welcome...

waiting for all kind of help.

thanks in advance for all people who replies...