Macro + Copy + Paste + different excels + using a condition

[bluej]

Hi,
I need a macro which can help me with the below:




1) For Unique Values in Input.xls excel
If Input.colA=Test Report.colA then
paste values in Test Report.col L, col M, col N & col O from Input.colB, col C, col D & col E for that row


2) For duplicate values in Input.xls excel
If Input.colA=Test Report.colA then
paste the summed values of Input.colB, col C, col D & col E in Test Report.col L, col M, col N & col O.


Error condition:
If Input1.colA does not exist in Test Report.colA, it should add up all such rows & paste in Test Report.colA = 'Miscellaneous Ones ' under col L, col M, col N & col O.
It should also create a sheet name Miscellaneous in Test Report excel & paste all the above rows there.


Please help me out.


Thanks,
Blue J