macro to create an output file "worksheet"

hi guys,


i need your expertise if this is possible using in vba.

i have an excel file that contains thousands of rows see attached excel file. i need to copy the "input" file put it in the "output" file. then insert an empty rows on below each rows based on the valueS ON "PEANUT" column see "output" file. then it will fill up the color based on the "reference" sheet.

hope you could help me.

thanks in advance.
P.S. i could not reply immediately since i dont have internet in my workplace..