in 2 different excel sheets copy & paste help

[blue J]

Hi,

I have attched the files for your reference.

Attachment 224922Attachment 224923
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 & pastInput.xlsTest Report.xlsxe all the above rows there.

Please help me out.

Thanks,
Blue J

[arlu1201]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.