combining 2 excell sheet

[sadiq]

I have a big list of excel file,i want to make it a template as easier.i dont know how to combine 2 files.kindly help me to make it easier. the attache file shows the simple form of template.like apple many reference repeats different cells,so how to automaticaly fill the data with each reference(like apple)..???

[sadiq]

please anyone help me...

[gebobs]

Is there any chance you could attach the file or a sample of it?

Let's name the fields so we can communicate better.

Sheet1: Product, Type
Sheet2: Type, Code

From what I can tell, this is essentially a one-to-many relationship with the key Type.

A few questions:
* Is it always 1:3 or did your examples just come out that way?
* Are there actually repeats of Product in the first table? Apple is listed twice.
* Maybe it doesn't really matter, but why are nuts1 and nuts2 distinguished?
* For the combined sheet, do you only want the Product listed once but the Type repeated for each Code?

[sadiq]

The Attached File Shows Example Of My File.Here The 5000016229
Is Repeting,Like That So Many Bom Will Be Repeat.The 3rd File Is My Final Template

[gebobs]

I don't see any attachments.

[sadiq]

I here by uploaded one excell file,kindly give me one solution.....

[sadiq]

Please anyone help me

[gebobs]

Use Access.