Merge two files

**alinagoo** · 04-19-2010, 02:45 PM

Hello all
I have tow different Excel files that they are common in a field, "Package_No",Is there a way to merge these two files and create a file with all data of two separate files?

Best wishes
A.M

**davesexcel** · 04-19-2010, 07:24 PM

Hello alinagoo,
Can you not copy and paste the data into a separate workbook?

**alinagoo** · 04-20-2010, 04:37 AM

Originally Posted by davesexcel

Hello alinagoo,
Can you not copy and paste the data into a separate workbook?

No copy paste is not possible because they have one to many relationship!
For example "package No. 1" comes in one row of first.xlsx but in second.xlsx "Package No.2" repeated in 5 rows.
?
Please help me

**davesexcel** · 04-20-2010, 08:12 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

**alinagoo** · 04-20-2010, 11:09 PM

Originally Posted by davesexcel

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

I must solve this problem by VBA(Something like Cartesian multiplication) however i have no enough time to do this right now!
Thanks
Bye

**darkyam** · 04-20-2010, 11:36 PM

Why must it be VBA? Formulaic or built-in feature solutions are almost always faster and more efficient, plus they have the added advantage of you being able to undo them if you need to.

**alinagoo** · 04-21-2010, 01:28 AM

Originally Posted by darkyam

Why must it be VBA? Formulaic or built-in feature solutions are almost always faster and more efficient, plus they have the added advantage of you being able to undo them if you need to.

Which built in solution?
Do you know any solution?
I don't think there is any solution! I think it must be customized bye VBA! A special program!
Maybe!

Thanks so

**darkyam** · 04-21-2010, 07:53 AM

It depends on what you want to do, which is why an example workbook would help us so much. From what I understand so far, though, I don't know why copy/paste and then sort wouldn't work for you.