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)..???